Database enfine could not lock the table

[Guest]

Error msg: The Database engine could not lock the table 'TABLE NAME' because
it is already in use by another person or process

It's located only on my 'C' drive - it's still in development and the table
in question is not open neither are any queries-reports-macros (anything)
referencing to it.

The table cannot be deleted or used. However, it does allow me to add new
records to it - although it will not be of any use based on the error message
above.

Anyone have any ideas as to what might have happened? One other point, this
was a table created with a Make Table query - and it didn't have any data in
it.

When I went into the table the Make Table was pulling from and critera to
match query (thereby having data to pull) and I changed the Table Name in the
Make Table to a new name and ran it again - it worked fine (with data).

However, I cannot delete the original (locked) one.

 

[Guest]

Check the ldb file (lock file). The ldb file is created in the same
directory as the mdb whenever the database is opened and has the same name as
the database with the different extension . If the database is not closed
normally then the ldb file probably was not deleted.

Try closing the database and then check the directory to see if the database
still exists. If so delete it manually.

Example:
db1.mdb
db1.ldb