Are you a regular user of MS Access? Do you face troubles while accessing it and get messages like:
If your answer is YES, you have hit the right page. MS Access Database is one of the most commonly used database application used these days. However, one cannot deny from the fact that like any other application MS Access is also prone to corruption because of which access database recovery is needed. There could be many reasons for the corruption of Access Database (MDB/ACCDB), such as:
To resolve these errors, Microsoft provides an inbuilt Compact and Repair utility which serves two distinct functions to recover Access database. At one end, it compresses Access database to remove the wasted white space while on the other hand it repairs the corrupted database file. As database may grow inadequately with insertion of various records, hence it is important to periodically compact the database to reduce its size or remove the extra space. It is observed that when user misses or fails to compact database, MDB file corruption occurs. For this, Microsoft’s Compact and Repair tool is the ideal software that ensures utmost database recovery.
The compact database tool can be used for databases created with Access 95 databases, MS Access 97, MS Access 2000, MS Access 2003, MS Access XP, Access 2007 and Access 2010.
Despite of having various benefits, this Access recovery tool has some limitation too. It is designed to restore corrupted tables, queries and indexes only and fails to restore the other database objects like report modules, forms and macros. These objects can only be restored from backup and the software is not enough strong to perform that way. Therefore, third party Access recovery tool is used.