Jet database engine stopped and locked access program

[Guest]

How do I reopen locked database. I was doing a search and replace in a table
when the db locked up. Now I get a message that the engine stopped because I
and another user were trying to change the same data at the same time. Not
possible because I am the only one with access to the db.

 

[Allen Browne]

Close Access. Open the Windows Explorer to the folder that contains the
database. You will see a small file with the same name as your database, and
an ldb extension. This file contains locking information. If Access does not
close down properly, this file can be left behind. Delete it.

If this does not solve the problem, you can probably get Access to rebuild
the database for you by following the steps for the first symptom in this
article:
Recovering from Corruption
at:
http://members.iinet.net.au/~allenbrowne/ser-47.html