Share via

Table Locked

Anonymous
2012-02-23T01:07:02+00:00

When I try and delete a table in my Access database I receive the following error message:

"You tried to lock table 'tProjects' while opening it, but the table cannot be locked because it is currently in use.  Wait a moment, and then try the operation again."

I have NO idea what other external database or process could possibly be locking my table.  Is there any way to find out?

Thanks,

Manuel

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2012-02-23T02:16:15+00:00

It might be you locking it - is tProjects open in a Form or Report, or locked by some VBA code?

If that's not it, close the database and see if there is a file in the folder with the database with the same filename but a .ldb extension. If so, this is a "locking" file left by some previous instance of Access which terminated abnormally. Delete the file and try again.

Was this answer helpful?

1 person found this answer helpful.
0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest