Monday, November 9, 2009

MS Access Data Loss after modifying data in some other application

The data saved in the MS Access database files (.mdb and .accdb) contains critical data in the forms of tables, views, forms and more. In most of the cases of opening the database files in other applications, the database becomes corrupt or inaccessible. To conquer such data loss situations, a perfect way is to restore the data from an updated backup. But, in case of absence of an updated backup, you will need to use advanced access repair application that can completely repair the corrupted Access database.

As a practical scenario, you open an .mdb file in the excel application. After making some changes in the MDB file, you save the database at the desired location. However, when you try to open your database, it shows an error message. In addition, the data saved in the Access database becomes inaccessible.

The core cause for microsoft access database inaccessibility is corruption of database due to opening it in another application. To avoid corruption of Access database, you will avoid opening of your database to other application.

To resolve the corruption of MS access database, you will need to use inbuilt repair utility named “Compact and Repair.” To use inbuilt utility, you will need to follow these steps:

1. Go to the Tools menu and select Database Utilities and then click Compact and Repair Database.

2. Locate and then click the database in the ‘Database to Compact From’ dialog box, and then click Compact.

3. Select an appropriate folder location for the new file in the ‘Compact Database Into’ dialog box, type a unique name for the file and then click on Save.

However, if Compact and Repair utility fails to repair the database, then you need to go for efficient Access Repair application. These access database repair applications use advanced scanning mechanisms to scan and repair the corrupted and damaged MS access database files.

No comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...