Record Locking and Sharing

[Guest]

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?

 

[Joseph Meehan]

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?

Do they have full rights, including delete to that network folder? Are
they opening the database "exclusively"?

 

[Guest]

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
__________________________________________

 

[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