Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Database engine can't lock table??

Database engine can't lock table??

Database engine can't lock table??

I have a table in Access 2000 that I cannot open or delete.  When I try to delete it I get this msg:

"The database engine could not lock table because it is already in use by another person or process"

I am the only user, I have re-installed several times and it won't go away.....Please help

RE: Database engine can't lock table??

You say that you have reinstalled; do you mean that you have reinstalled Access?  Have you compacted the database?  Also try importing the table into another database?


RE: Database engine can't lock table??

You may have multiple copies of the database open. Maybe it is linked to another mdb which is open.

RE: Database engine can't lock table??

Two things to try:
    With Access off, go and find the .LDb that may be sitting beside your database. Delete it. (It is rebuilt each time the Db is opened.)
    Look through the table for what I would call a "jammed" record: could be in any field, and usually says #deleted#.
If you find one like this it is holding up the whole mess. You can try to delete it or try to copy all the other records to another table (not a fun process...) Good luck,


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close