Wednesday, August 5, 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 Windows based systems, you are provided with the facility to open the access database files in other applications (such as Excel, PowerPoint, Word, and more) as well. In most of the cases of opening the database files in other applications, the database becomes corrupt or inaccessible. To overcome such data loss situations, an ideal 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 database repair application that can completely repair the corrupted Access database.

As a practical scenario, you open an Access database (.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 attempt to open your database, it shows an error message. In addition, the data saved in the Access database becomes inaccessible and does not open from any other applications as well.


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


To resolve the corruption of Access database, you will need to use an inbuilt repair utility named “Compact and Repair.” To use the inbuilt utility, you will need to follow the below 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 will need to go for effective Access Repair application. These Access Database Repair applications use advanced scanning mechanisms to scan and repair the corrupted Access database files.

Stellar Phoenix access recovery is feature rich Access Database Repair software that can restore and Repair Access database objects like tables, queries, forms, reports, macros and modules. The read only software is compatible with Microsoft Access 2007, 2003, XP (2002) and 2000. It supports Windows Vista, XP, 2003, 2000 and NT.

No comments:

Post a Comment