How to turn off record locks?

V

Van

Hello,

I receintly utilized the Book collection database template from the
microsoft website as the basis for a database that I further enhanced. I can
not seem to get the database to turn off record locking. I have gone into the
properties and all seems to be accurate, but only one user can alter the
database at a time. Any assistance that you may offer would be greatly
appreciated. Thank you for your time.
 
T

Tom Wickerath

Hi Van,

I suspect that the users do not have full privileges to the shared folder.
Each user needs to have RWCD, in order for the locking database file to be
properly created, updated, and deleted. Please see the following KB article:

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

Also, check out my list of suggestions here:

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


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

Hello,

I recently utilized the Book collection database template from the
microsoft website as the basis for a database that I further enhanced. I can
not seem to get the database to turn off record locking. I have gone into the
properties and all seems to be accurate, but only one user can alter the
database at a time. Any assistance that you may offer would be greatly
appreciated. Thank you for your time.
 
Top