Could not update; currently locked.

[McCabeTC]

I have a multiuser Access 2000 database that is opened through a Windows shortcut. Occasionally, we will get the error message "Could not update; currently locked". Microsoft states that this happens because when a database is opened through a Windows shortcut, the Jet engine will use page-level locking instead of record-level locking. To fix this problem they suggest to download Microsoft Office 2000 SR1/SR1-a. Well, I did this already (to all the users' machines), and we are still experiencing the problem. Does anybody out there had this problem before? Could find a solution for it?
I'll appreciate any help you can give me on that.

Thanks,

TM

 

[KenReay]

Hi

Even with row level locking, you may get a situation whwre two users attempt to update the sane record at the same time are you sure that this "error" in not in fact a genuine record lock situation?

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[McCabeTC]

Thanks for raising this question. But, I programmed the system throught VBA to only allow each user to edit/view their own clients, in that way, they cannot access each other's records.

TM