I have developed an Access application to administer competitons for a
photography club. Now, because of the workload entering all the data, I
am looking to make it multi-user. That, in itself, is not a problem, and
I have done such apps in the past.

I am attempting to send a databse that I have built in Access 97 that
is part of a workgroup on our server.  The person I am sending this to
is not able to access the database because of errors involving joining
a workgroup. How can I save/send this database without the workgroup

I have a split FE/BE a97 mdb, with 4 PCs on a peer-to-peer W2k network each
with their own FE, and a BE on a fileserver running w2kserver.
Whenever I try to do a compact/repair on the FE on my PC I get "The
microsoft jet database engine stopped the process because you and another

Which is faster, if any, when accessing a backend from a local fronted over
a network -
mapping the share to a driveletter og just using the sharename?
Does it matter?

I'm using Access 2003. I have a database that I want to allow all users to
view, and print reports, some users to be allowed to enter all of the data,
and finally some of the users to be limited to entering data in specific
fields. Is this possible? The form is tabbed.

I will be splitting my database in the next month or so after more input and
testing from management.  I will have access to a SQL server.... So here are
my questions.
1.  If the database is going on a SQL server, are there additional steps I

I have about 15 users in my database and quite often I get error message
number 1206 "Could not find field 'Description'". Would this be related that
I haven't set yet edited record-locking = as soos as one user begins to edit
a record, no other user can make any changes to it ...

After setting security & splitting the database, I need to place an icon on
each user's desktop so they may just click & view the database.
How do I do this?

I share the MDW file in the server. If the second user execute the shortcut,
there is an error message "file is already in use".
How to solve this problem ?
Thanks.

I have an AC2000 Database running in AC2k3 that users are now getting
this error:
The microsoft jet database engine stopped the process because you and
another user are attempting to change the same data at the same time

dear sir,
i am working as a system administrator, we are using windows 2000
server DC 180 nods . this is the institute. wen our students is using
mapped drive at a time then network will be  very slow..

How can I determine wich users (or machines) are logged onto a back-end
database?
(in case of maintenance ?)
And how can I kick them out (after a first friendly request)

For the past 9 years we have had a database (split) .Server 2000. Two
buildings (One server) T1 line connecting the two. The building
farthest away has now started giving disk or network errors.
The network administrator says it is the database. I disagree.

I have a standard multi-user Access database with a backend, a design master
and a master replica.  Each user makes a replica of the master replica and
synchronized to the master replica.  I synchronize changes to the design
master also to the master replica.

This annoying error message from MS Access "MSACCESS.exe has generated
errors and will be closed by Windows. ... "
Keeps happening for most versions of MS Access like 95, 97, 2000, that I am
aware of.