Database defaulting to Open exclusive

  • Thread starter Thread starter Rose
  • Start date Start date
R

Rose

I have an inherited Access 97 database (now converted to
Access 2000), which seems to only allow one person in at a
time, unless they go as read only. (appears as if it is
open exclusive, even though this option is not used).

We need to be able to get several people in at a time and
just have record level locking. We have tried the
following:

- checked Tools, options, advanced - "shared" is ticked
and also "no locks".

- We have gone into the database specifically using File
Open, rather than Open Exclusive

- I have tried importing the tables, forms etc into a new
database

- Have also tried a repair and compact.

- Have checked the properties of the file itself.

Does anyone know how to make the database available to
several people at once?

Thanks
 
Hi, Rose.

You are experiencing this problem because the multiple users can't lock the
records, so must either open the database as "read-only" or in exclusive
mode, even if the database is set to use shared mode.

In order for multiple users to open a database at the same time, all of
these users must have "full control" permissions on the directory where the
file is located. If any one of them (even someone you decide for some
reason should be "read-only") doesn't have "full control" (create, modify,
read, and delete) permissions on the directory, then the locking database
file (*.LDB), or lack thereof, will interfere with the others trying to use
the database file.

Also, if this database isn't already split into a front-end and back-end
database, then I recommend that you split it and place the back-end on the
shared network server and a copy of the front-end on each user's
workstation. This will help prevent database corruption as well as give you
several other benefits. You can find more information on split databases on
this Web page:

http://www.Access.QBuilt.com/html/gem_tips.html#SplitDB

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Any human can read my reply E-mail address and should alter it so that a
message will be forwarded to me. Spammers are free to use my UNALTERED
reply E-mail address. I will *never* get those messages!)
 
Back
Top