error message "Could not update; currently locked"

Hello,

I have a table in my database which is a change log.
So when users make a change it records the previous and new values.


It's a simple "INSERT" statement run by the .Execute method on the ADO connection.


Most of the time there is no problem, but every now and then this fails with the error "Could not update; Currently locked".
The issue affects all users and I can't really work out why this happens, who's locked it or what I'm not/doing which causes it or how to fix it?

It may be possible that someone closed their session erroneously and locked the database. Suggest have everyone log out. Go the the folder where the DB is housed and see if there is .laccbd file still open with the same DB name. If so, delete it and see if this solves your issuse.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.