Tuesday, November 10, 2009

Strange Error Messages in MS Access database

Whenever you open your Microsoft Access database, a LDB (Locking Database) file is automatically created in the same directory. The file is primarily used by Jet Database engine to prevent database users from writing data on pages that are locked by any other database user. LDB file gets deleted when the user quits from the database. While the LDB file is automatically deleted in most cases after database shutdown, it exists in case your Access database is corrupted or damaged. In such situations, you might encounter many strange error messages related to LDB file. This can further cause more corruption to your database and result in huge losses. To avoid such situations, you can restore the data from an updated backup. However, if no backup is available or backup falls short to restore the desired information, then you will need to search for the effective repair access software.

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 on computer computer name.”

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.

No comments:

Post a Comment