Record Locking and Sharing

  • Thread starter The Dummy in Access for Dummies
  • Start date
T

The Dummy in Access for Dummies

I disabled all record locking and allowed sharing, but it still will only
allow one person in the database at a time. Is there a reason why? The
Database is on a network and everyone on that logs on is automatically
considered a system user. Security is not on, so could this be a network
issue?
 
T

Tom Wickerath

As Joseph indicates, all users need to have RWCD privileges for the folder.
Please see the following KB article:

Introduction to .ldb Files
http://support.microsoft.com/?id=299373

You may also be interested in this article:

Implementing a Successful Multiuser Access/JET Application
http://www.access.qbuilt.com/html/multiuser_applications.html


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
 
A

aaron.kempf

you just need to move to ADP

ADP works the first time and it doesn't throw random locking problems

keep all your queries in one place-- stored procedures are infinitely
more powerful than MDB queries.

any day of the week-- I'll take a single sproc against 1,000 Access
queries
 
Top