Could not update; currently locked

Question

Hi,

A group of users who share an Access DB get "Could not update; currently locked" error. It used to work find. But after using it extensively with data update, the error reoccurs. Is that because the Database has been corrupted or something is not cleared probably? Or does any of the following command cause the lock? 

1. DoCmd.RunCommand acCmdSaveRecord
2. DoCmd.RunCommand acCmdSelectRecord
3. DoCmd.RunCommand acCmdCopy
4. DoCmd.RunCommand acCmdRecordsGoToNew
5. DoCmd.RunCommand acCmdPaste
6. .Requery

Should the user open the database in another way or should I use other command to avoid the lock?

Please advice. Your help would be greatly

Answer 1

Hi. Is you database application "split" into a front and a back end? If not, it should be. Just curious...

Answer 2

I'm not first thinking of corruption. Your code is very curious because it makes an exact copy of a record and saves it. That is RARELY a good idea. Can you explain why this is an exception? Or are we looking at bad database design?

Like the DB guy I'm very concerned about "share an Access DB". Users should share the back-end, but must have individual front-ends. This is a FAQ.

---

-Tom. Microsoft Access MVP