Monday, January 9, 2012

Top 5 Common Causes of Access Database MDB File Corruption

The 5 leading causes of Access database MDF file Corruption due to these causes database get corrupt. I am sharing more information as below:

Sudden shut down of Access Database: Sometimes when we perform any action on access database, the database get suddenly shut down due to power failure. In this case, the Jet database engine may mark the file as suspect or corrupted.

Storage Device Failure: if your hard drive has some bad sectors and you save  MDB file on these bad sectors. Then you are not able to read MDB file. Or the  mdb file you read are incorrect entries or full of errors.

Opening and Saving the MDB File in Another Application: Sometime user open the mdb file & save it in to different file format or Open & save file in to different application like Microsoft Word allows to opening & saving an Access database file. Saving the file in this manner is also a cause of mdb file corruption

Updating Service Packs: Different Microsoft Access Services or Service Packs of Jet Releases time to time or these packs installed on PCs can also cause of database corruption.

Virus or Other Malicious Software: Viruses infected and corrupted the MDB files or make them inaccessible.

In some corruption scenarios database can recover & in some scenarios it can't. The scenarios are:

There is no method to recover mdb file that was open & save in another program
Mdb corruption due to Hardware corruption is also difficult to resolve.

To resolve mdb file corruption use these methods:

Make a backup: When mdb file marked corrupted. First You should make a backup copy of the corrupted file and than put it in another folder. If recovery techniques fails on original corrupted file then you can use this copy.

Compacting Access Database: Try to compact/ repair the corrupt mdb file, but once the compact process finishes, open the file and check ALL its objects for data loss.

Check MSysCompactErrors: Check that MsysCompactErrors has any new entries or hasn’t been created. If it does, then these records document the objects and or data removed as part of the repair.

Make a backup of the repaired file: After that also make a backup copy of repaired file for your future reference.

Make a new Database: create a new database and import all repaired object in new database.

Third Party Tools: Use third party Access database recovery tool to recover severely corrupt mdb files.
Enhanced by Zemanta

No comments:

Post a Comment