A Microsoft Access database may consist of data and indexes as well as the database objects: tables, queries, reports, forms, macros and modules. The best way to protect against loss of data and databases due to corruption is to backup your databases often. Microsoft Access provides a Compact and Repair utility to assist in recovering corrupted databases. However, these utilities have limitations and may not fully recover the database, its objects or its data management functions.
The Compact Utility reduces the physical size of your database by making an exact duplicate of the database while also ridding the database of any excess space created by deleting and modifying data. The deletion of records and the reduction in record sizes, within a database, does not reduce the size of the overall database. Compacting is the only way to reduce the size of databases. The more additions, deletions and modifications performed on databases, the more often they need to be compacted.
The Repair Utility is limited in its capability because it only attempts to repair corrupted tables, queries and indexes. The utility cannot repair forms, reports, modules or macros. These objects can only be recovered from a backup. The Repair Utility performs the following functions:
A corrupt database may generate error messages, which indicate the cause of the corruption. If errors indicate that the corruption is specific to a database object, you may create a new Microsoft Access database, import the undamaged objects from the corrupted database and restore the corrupted objects from backup.
If errors indicate corruption due to a Visual Basic Application (VBA) or macro, you may recover the affected tables, queries and macros by exporting them from the corrupted database and into a new database. However, you will not be able to export forms, reports and modules. These objects must be recovered from backup.
If errors indicate corruption due to VBA projects, the project stream may exceed the size allowed for your version of Microsoft Access. Installing the appropriate service pack will resolve this problem.
If errors indicate corruption due to the Jet Database or corruption is detected by some other means, the following steps outline processes to restore the corrupted database.
NOTE: If one or more records, of the damaged table, contained fields of Data Type, Auto Number and the Field Size property of the new table was set to Long Integer, you must create, yet, another table to restore the Auto Number values:
AutoNumber values should be recovered correctly.
If none of the above steps provides a means of recovering your corrupted database and data, you may either seek a third party solution from software vendors that specialize in data recovery or restore your database from backup.
AccessFIX is an Microsoft Access database repair and recovery Software that restores damaged MS Access files, rebuilding the table data. This utility works with MS Access 95, 97, 2000, XP, and 2003
Restore your database files easily in only 15 minutes:
Download the free database repair and recovery software demo now to evaluate the recovery capabilities of the program. Once AccessFIX demo is installed you will easily recover your database file and view the results with only a few clicks.