Multi-User DB

[KBV]

I have a small db where I changed the default under Tools, Option, Advanced
to Shared and "edited record lock" . However, whenever a user opens a form
(that pulls multiple records when you scroll, the db is still locking up and
preventing User 2 from opening the db at all). In order to overcome that,
I've had to elminate all locking completely, but am concerned about the
integrity (with regards to 2 people making modifications to the same data at
the same time).

Can I still keep edit record locking and allow multiple users to use?

Thanks,
KBV

 

[ChrisM]

If you have multi-user access to your database, you should split it, that is
have one database that lives on the server with all the data-tables, and on
each users computer, a copy of another database that contains all the
queries, forms etc. and linked tables that link back to the ones on the
master DB on the server.

There is plenty of further detail on this both in this NG and if you have a
google.

You also might want to see if the database if being opened in 'Exclusive
Mode'

Cheers,

Chris.

 

[KBV]

How do I prevent one user from opening in "exclusive mode". I had set the
default to "shared"...

Please advise.

 

[Dirk Goldgar]

How do I prevent one user from opening in "exclusive mode". I had set
the default to "shared"...

One thing that may be forcing exclusive access even if you've set the
default open mode to shared is the users' permissions on the folder
where the back-end database is stored. The users must have full
permissions on that folder -- read, write, create, and delete.
Otherwise, Access can't create the lock file (.ldb file) in that folder,
which is necessary to manage locking. If the lock file can't be
created, Access is forced to lock the whole database for each user,
which means the first user in gets exclusive access.

 

[Rick Brandt]

How do I prevent one user from opening in "exclusive mode". I had set
the default to "shared"...

Please advise.

The default open mode is an option for "your installation of Access", not
the file that you have opened at the time you set it. In other words
setting that on your PC has zero affect on the default open mode on everyone
else's PC.