Multiple Users

[Brian]

I have created a small database that is meant to be
accessed by many people. The people accessing it will not
be editing anything directly, just querying for
information based upon their input from Combo boxes. For
some reason, I am unable to get two people onto it at the
same time. I have the Default Open Mode set to shared yet
still get an "...Opened exclusively by another user..."
error. It is on a server that both people have write
access to. I have other databases that are set up almost
identically as this one and they do not run into this
problem. What could be the cause of this? Are there any
interactions between forms and queries and tables that
could trigger this? Any help, even list of things to look
at would be very much appreciated. Thanks.

 

[Joan Wild]

Users should also have create and delete permissions on the folder. Without
the create permission, the first person in can't create the associated ldb
file, and the mdb is opened exclusively.

Also you should split the database, leaving the backend on the server. Give
each user a copy of the frontend on their workstation.