Consider a practical scenario, where your Access database has been corrupted and the LDB file did not get deleted. This further leads in producing strange error messages like:
“Couldn't lock table table name; currently in use by user
To resolve the above error message and to avoid any further corruption, delete the LDB file and repair the database using the following steps:
Select “Database Utilities” on the Tools menu,and then click Compact and Repair Database.
Search for the database file in the ‘Database to Compact From’ dialog box, and then click Compact.
Select a new folder location for the new file in the ‘Compact Database Into’ dialog box.
Provide a valid, new, and unique name for the database file and
Click on Save.
In most cases, the above repair steps allow you resolve your problem and access the database. However, if the inbuilt repair utility fails to repair the corrupted database, you will need to search for
Access Database Repair application. These access database repair tools employ high end scanning algorithms to orderly repair corrupt MS Access database.