Saturday, January 2, 2010

Fixing “Microsoft Office Access can't compact and repair...” Error Message

Severe corruption in MS Access database primarily results in unmountability of database and complete inaccessibility of its records. Few main reasons for acute corruption of Access database file could be fatal virus attack, continuous improper shutdown of the database, and application malfunction. To access your database records after severe corruption, an easy way is to restore the data from an updated backup. However, if the database is not handy or it is not feasible to restore the data from the backup, then the only choice left is to use advanced third-party access database repair application.

Consider a practical situation, where your database gets severely corrupted and you attempt to repair it by using “Compact and Repair”. To do so, you follow the below mentioned steps:

1.The first step is to click Tools option on the Toolbar menu.
2.Now select Database Utilities from the drop-down list. Click 'Compact and Repair Database' option.
3.Next, choose the corrupt Access database in 'Database to Compact From'.
4.To begin with compact and repair, click 'Compact'.

However, while the compacting and repairing process was ongoing, the below error message pops up:

“Microsoft Office Access can't compact and repair the current database.”

The above error message pops up every time you attempt to repair the database by using “Compact and Repair”.

Cause:

As stated in the error message, the MS Access is unable to compact and repair the database. The root cause for the occurrence of the above error message is severe corruption of your database.

Resolution:

To resolve the above error message and to access the records stored in the database, you will need to use advanced third-party access repair application. An Access Repair tool uses powerful scanning methods to perform absolute repair of corrupt database. It provides safe database repair, without making any overwriting or modifications in the original file. The repair utility is embedded with highly interactive documentation that makes it easy to understand. There is no requirement of prior technical knowledge to perform the repair process.

No comments:

Post a Comment