Thursday, August 13, 2009

Could not update; currently locked [Error Fix][Access 2003]

If your table is has a stuck lock in it then you may encounter one or more of the following errors:

THE ERROR:
When running an insert query - "Could not add # record(s) due to lock violations"
From code or currentdb.execute - Error # 3218 - "Could not update; currently locked"
Direct table editing - "Could not update; currently locked"

THE FIX:
Compact and repair the database should resolve the problem.

No comments: