By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,471 Members | 2,264 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,471 IT Pros & Developers. It's quick & easy.

Record Lock

P: 3
Hello,

Sorry to bother you with what I am sure is a simple question about access but I am unsure about something.

I have a database which comes up with a Record Locked error message when multiple users are editing the records, the issue is that none of them are editing the same record although they are all going through the same query. (but their own client version) but should be picking up different records due to different criteria.

If I turn of Record Lock all together what potential issues could be caused? Will it do more harm than good?

Thanks

Adam
Oct 18 '07 #1
Share this Question
Share on Google+
1 Reply


nico5038
Expert 2.5K+
P: 3,072
Makes sure that the Tools/Options specify that the database is used "Shared".
Another "locking" problem can be caused by the fact that one user opens an object in design mode. (Or even an open in design mode by VBA code).

Access will handle concurrent update problems by warning a user, so it's indeed not necessary to lock records in general.

Nic;o)
Oct 18 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.