Record Lock

[ABrown]

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

[nico5038]

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)