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 ; currently in use by user on computer .

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.

by: colindolly

POST COMMENT

Concisepc Of Livonia Has Data Backup Solution So That You Don't Have To Worry About It? Concise Of Lake Orion Has Computer Trouble Shooting Skills That Includes Fixing The Client As Well To Concise Computer Consulting Of Birmingham, Pc Trouble Shooting Includes Fixing The Client As Well Are You Prepared For A Disaster? Is Your Disaster Recovery Plan The Best It Can Be? How To Solve When Outlook Pst Stops Receiving Emails? Microsoft Outlook Recovery - Pst Inaccessible After Moving From Network Share Recover Photos From Cf Cards Best Practice To Effectively Handle Logically Crashed Storage Media How To Get Data Solution For The Raid Recovery And Server Recovery Tips To Prevent Outlook Express Messages From Disappearing How To Resolve unrecognized Database Format Access Database Error Error Message While Compiling Ms Access Database Event 217 And 478 While Backing Up Exchange Database