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/