Numerous things can happen, both inside and outside of Access, which may potentially damage your database file. The symptoms of a corrupted database can range from #Deleted appearing in certain records, not allowing you to open one of the objects in the database, unable to open the database file in Access altogether. The built-in Compact and Repair utility in Microsoft Access is a useful tool for trying to optimize or trying to repair Microsoft Access database files. This article shows the basic steps to compact Access database with this utility and beyond. It also explains what work beyond Compact and repair tool to provide you extra support.

Why .mdb files may become corrupted

MS Access database uses MDB and ACCDB files are used to store data. There are three main reasons why an .mdb file may become corrupted, as follows:

1.Interrupted write operation

2.Faulty networking hardware

3.Opening and saving the .mdb file in another program

Compact and Repair

The repair process inculcated within this tool tries to repair only the tables, the queries, and the indexes in the database. It does not try to repair damaged forms, reports, macros, or modules.

Open the Compact and Repair utility and use it to compact access database. To do so, follow these steps:

1.If the database is open, close it.

2.On the Tools menu, point to Database Utilities, and then click Compact and Repair Database.

3.In the Database to Compact From dialog box, select the file that you want to compact, and then click Compact.

4.In the Compact Database Into dialog box, enter a new file name, and then click Save.

If the compact and repair does not succeed, you will receive a message stating so. This means the damage is severe that it cannot be corrected. What now! This will be the most probable query in one’s mind. Well the answer is, use dedicated third party software to repair the corrupted database.

Repair tool will compacts and traces out all the data trapped within the damaged files. Then they are either rebuilt or stored in a new database and thus all your data remains and access is regained.

Salient features of the recovery tool are:

1.Performs fast and accurate repairing of the corrupt MDB or ACCDB database files

2.Restores most important data structures such as auto number, primary key, field size and many more

3.Successfully retrieves damage tables, table data, Indexes, Field Properties.

4.Recovers accurate table structure details, including all indexes, Relationship and all types of fields.

5.Capable of recovering even password protected Access databases

Recoveryfix for Access

This is excellent compact access database software featuring all the above properties and more. This tool has two recovery modes to obtain optimum results, i.e. Standard mode to rebuild the existing database and Template mode to recreate a new database. It also features Live Preview technology to display the database file content and structure. Use it to compact access 2007 database and every other version from MS Access 2010, 2003, XP to Access 2000. Try the fully functional free evaluation version to check its worth.