Saturday, October 24, 2009

Causes and Resolutions for Access 2007 database corruption

MS Access 2007, a significant release by Microsoft, allows you to create and maintain databases with more ease in comparison to its older versions. While the later version is built with powerful features like rich text, split forms, image control, etc., the security features lack to save your database files from being corrupted or damaged. Two major hazards that you encounter after Access database corruption are unmountability of database and inaccessibility of records saved in it. These hazards fail to affect you if you have maintained a valid and complete backup of your database. However, the hazards may be a cause of worry in case your backup has been corrupted or you have not maintained any database backup. In such situations, if you need to access the records saved in your Access 2007 database file (.accdb), then you will need to opt for advanced access database repair application.

Few most common scenarios under which your .accdb file can get corrupted or damaged are discussed below:

Improper System shutdown
Operating System corruption
Application Malfunction
Virus Attack
Simultaneous modifications in Access database components
Human errors

While the percentage of corruption may differ in the above scenarios, the outcome for all of them remains the same – inaccessibility of Access database records. In most cases, you encounter an error message stating the cause of the corruption.

To comprehensively resolve Access database corruption and access database records, the inbuilt repair utility “Compact and Repair” comes to rescue. To use the repair utility, you will need to follow the below steps:
1.Choose “Database Utilities” under “Tools” drop down list. Next, click “Compact and Repair Database.”
2.Click Compact after locating the database in the ‘Database to Compact From’ dialog box.
3.Select a new folder destination for the repaired file in the ‘Compact Database Into’ dialog box. Give a unique name to the file.
4.Click on Save.

While the above utility repairs corrupt Access database in most cases, the failure of it results in usage of third party Access Database Repair applications. Such repair access tools use high end scanning methods to repair the corrupted Access databases.

No comments:

Post a Comment