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.
Thursday, August 13, 2009
Subscribe to:
Posts (Atom)