For a regular user of Microsoft Access importance of keeping the MDB file corruption free is like completing a non-achievable target. This is because MDB files are more vulnerable to damage as they increase in size. A corruption free MDB file is must for smoothly retrieving and updating data in it. Once the MDB file is damaged, you cannot access it and same is with the data stored in it. You loss all of the crucial information stored in the damaged MDB file. There are so many factors that make your MDB file damaged. Following are some of the reasons that make the Access database file damaged:

• Power sabotage

• Virus infection

• Sudden system shut down

• Hard disk crash

• Malfunctioning of MS Access

• Abrupt closing of database file

You can have a damaged MDB file due to any of these reasons. Therefore, you must consider following tips to keep your database file damage free:

1. Regularly scan the location where MDB file is stored to find and delete the possible virus threats. A virus generally deletes the header of the file and renames the file to some xyz extension. Due to change in the extension, MS Access cannot recognize the file and throws "file cannot be recognized" error message.

2. Always close the MDB file in a proper way.

3. Shut down your computer system after manually closing all applications running on your computer's desktop. This is a precautionary step to protect the Access database file corruption free.

4. Never format the hard disk partition containing MDB file without taking its backup. Formatting deletes all data stored on the selected hard disk partition.

5. Keep splitting the database instead of having a large sized MDB file because a large sized MDB file is more vulnerable to damage than a small sized MS Access database file.

6. Always close all database connections before exiting the database.

These are some of the tips that help you keep MDB file away from corruptions. However, if you have already faced the MDB corruption then you require a third party MDB repair tool for getting the lost data back in your hand. An effective MDB repair tool maintains data integrity and consistency when repairing the damaged MDB file.

Kernel for Access - a prudent, cost effective, and easy to use third party MDB repair tool, which enables you to repair the MDB files with full accuracy. The software recovers every item from the damaged MDB file and provides you with the repaired MDB file that can be directly used without any modifications. The software supports all versions of MS Access starting from Access 95.

Article Source: http://www.ArticleBlast.com