Monday, November 16, 2009

Compact and Repair Utility resulting in Complete data loss

With the advancement in versions of Microsoft Access application, numerous features have been added that enable you to manage and store your database records in a more efficient manner. Microsoft Access 2007, the latest versions of Access, incorporates many such features that make it a perfect database application to be used for various purposes. MS Access 2007 being a technical application is bound to be corrupted due to various factors like, improper system shutdown, virus attack, application malfunction, and more. Once the database is corrupted, your database becomes unmountable and the records saved in it becomes inaccessible. To successfully repair your database, an easy way is to use an inbuilt repair utility named “Compact and Repair”. Although the repair utility repairs the database in most situations, it can also result in complete loss of data. In order to avoid any such scenario, it is always recommended to use advance third-party access repair applications to repair your database.

Consider a practical scenario, where your Access 2007 database gets corrupted due to improper shutdown. You follow the below steps to repair your corrupted database:

Select “Database Utilities” option on the Tools menu.
Click on Compact and Repair Database option.
Locate for database file in the ‘Database to Compact From’ dialog box. Click on Compact.
Select a new folder destination for the new file in the ‘Compact Database Into’ dialog box.
Provide a valid, and new name for the database file. Click on Save option.

However, after the compaction process is complete, Access 2007 may display a warning message. The warning message states that it can not delete name.accdb file and suggests that you will need to remove the read-only status and then click OK. If you click OK, your database is completely damaged.

Note: Never click OK when the warning message appears.

To avoid any such Access database damage situations, you will need to repair the database using third-party access repair software applications. Such Access Repair tools use intensive scanning mechanisms to repair corrupt MS Access database and recover all inaccessible database components.

No comments:

Post a Comment