Friday, January 15, 2010

Handling Errors post Accdb and Mdb files Damage

Access database files (.accdb/.mdb) corruption can be easily identified when you receive one or more error message while mounting the database. While the reasons for file corruption could be many, the result in most cases is the same – inaccessibility of database file records. In such cases, the most convenient way to access you records is by restoring them from an updated backup. Most of the Access database users maintain a valid backup, mainly on another storage media. However, if the users forget to create a backup or the storage media gets physically damaged, then they need to repair the database by using a powerful third-party repair access application.

Below are certain error messages that appear after the Access database files get corrupted:

“A problem occurred in your database. Correct the problem by repairing and compacting the
database.”
Or
“You requested an invalid file. The file may be corrupt. Contact the person who created the file
and request a new copy.”
Or
“Microsoft Office Access can't compact and repair the current database.”

Such errors primarily result in making the database file records inaccessible.

Resolution:

To repair corrupt MS Access database files, you will need to use an inbuilt repair utility known as “Compact and Repair”. Compacting and repairing can be performed by following below steps:

1.To start, click 'Tools' button on the toolbar menu.
2.Next, select the option 'Compact and Repair Database'. The option is available in 'Database Utilities' list.
3.Select the corrupt Access database file under the option 'Database to Compact From’.
4.Click 'Compact'.
5.Assign a new and unique name to repaired Access database file.
6.Click 'Save'.

The above steps to repair the Access database files prove successful in most corruption scenarios. However, if the corruption persists even after following the above steps, then you will need to use advanced access repair application to repair the files.

The Access Repair application can be easily downloaded from Internet and the repairing can be performed even by a novice user. The repair tool is completely non-destructive, as it does not make any modifications in the original content of the file.

No comments:

Post a Comment