Since MS Access application is a data file, it is likely to be effected by damage, error, and corruption.
A number of factors are responsible for the corruption of MS Access files. Some of the reasons are as follows: software crash, media corruption, virus corruption, sudden system shutdown, etc.
Once the MS Access file or the .mdb file becomes corrupt, all the data present in the MS Access database becomes inaccessible. Not only this, corruption in the MS Access database or the .mdb file may lead to data deletion from the MS Access database. The user cannot do away with these problems. Thus, you need to quickly think of an efficient recovery mechanism that would accurately restore your data from the MS Access database or the .mdb file.
Microsoft provides its users with a free utility which is known as the Compact and Repair utility. This utility is capable of repairing the MS Access database or the .mdb file. This tool does not limit itself to repairing the .mdb file but also reduces the unused space in the MDB database.
Now let’s understand as to what is an unused space in the MDB database?
An unused space is created in the MDB database whenever an object or a record is deleted from the MDB table. The compact and repair utility deletes this unused space.
The MDB repair process of the Compact and Repair utility is as follows: it copies all the objects from the old, corrupt MDB database, hence restores all the objects and then saves them in a new MDB database at a new location.
Though Compact and Repair utility has the potential to perform Access repair, it has few limitations as well. Since Compact and Repair utility is a free tool, it is unable to restore the MDB database with complete efficiency. Yet another drawback of this utility is though it is capable of repairing the tables, queries and the indexes in the MDB database, it cannot repair the damaged forms, reports, macros or modules.
Kernel for Access is one such efficient and powerful third party Access repair tool. Using this tool, you can efficiently and accurately perform Access repair. For more information please visit: http://www.repairaccess.org/