Monday, December 28, 2009

Tips to resolve “Microsoft Office Access was unable to completely repair...”

In most cases, the database users are unable to identify the exact cause of MS Access database corruption. This is the reason that they mostly land up in further corrupting their database. Corruption in your database can either be caused due to logical factors (improper system shutdown, application malfunction, and virus attack) or physical factors (accidental dropping, fire, water, natural disasters, etc.). An easy way that most database users follow to overcome the corruption scenarios is by restoring the data from an updated backup. However, there are many situations where the users have either not created any backup or their backup file gets corrupted. In such situations (for logically corrupted databases), they need to perform access repair by either using a third-party repair application.

Consider a practical scenario, where your MS Access database does not mount due to corruption. Furthermore, you also encounter the below error message:

“Microsoft Office Access was unable to completely repair the '|' table and deleted some Memo,
OLE Object, or Hyperlink field values. To recover the data, restore from your backup copy of
the database....”

All your database records become inaccessible after the the database becomes unmountable.


Logical corruption of your database.


A simple solution (as stated in error message) to the above error message is to restore the data from an updated database backup. However, if in absence of database backup, you will need to compact and repair your database using below steps:

1.Click 'Tools' option on toolbar menu and choose 'Database Utilities' in the drop down list.
2.Next, click 'Compact and Repair Database' option
3.Select damaged database file in ‘Database to Compact From’.
4.Start the compact and repair process by clicking on 'Compact'.
5.Store repaired database file on your desired destination.
6.Lastly, click 'Save'.

However, if the above error message appears even after following the aforementioned steps, then your database is severely corrupted and needs a third-party access database repair tool to perform repair. Such Access Repair applications perform repair by using advanced scanning algorithms. Moreover, these applications come highly graphical user documentation, which makes them easy-to-understand without any prior technical understanding.

No comments:

Post a Comment