MS Access application malfunction is one of the main reasons for corruption of Access database files (.mdb and .accdb). Malfunctioning primarily occurs due to improper shutdown of the application, virus attack, or accidentally deleting the necessary files of the application. In most cases of application malfunctioning, an error message pops up on the screen, resulting into inaccessibility of all database file records. To easily cope up with such Access database corruption scenarios, most of the database users maintain an adequate backup. But if in case, the users forget to create an adequate backup or backup falls short to restore the preferred database records, then the database users need to repair their database by using an advanced access repair software.
Lets take a practical instance to discuss the above case. Below is an error message that occurs when you attempt open a database file created in either Access 2002, 2003, or 2007:
“Microsoft Access encountered an unexpected error while attempting to recover from a failed save (or send). Your data access page may not be in a usable state. Please attempt to save to a different location.”
This error message does not allow you to mount your database and makes the database records inaccessible. The same error message appears for MS Access 2002, 2003, or 2007 application.
Cause:
Above error message primarily appears when the database file gets damaged due to application malfunction.
Resolution:
To resolve the above error, MS Access repair utility “Compact and Repair” needs to be used. Below are the steps that enable you to use the repair utility:
1.Select 'Tools' option.
2.Choose 'Compact and Repair Database' option.
3.Select 'Database to Compact From’ option.
4.Click 'Compact' option.
5.Click 'Save' option.
The repair utility ensures access database repair in most corruption scenarios. However, if the repair utility fails to resolves the corruption, then you will need to use an advanced Access Repair application. A third-party repair application can be downloaded from the Internet and used to repair the database, regardless of their cause of corruption.
Access Recovery is an effective Access Database Repair software to repair database files created in MS Access 2007, 2003, XP (2002), and 2000. The non-destructive repair utility provides complete safety to the original file, by keeping it untouched. It is compatible with Windows 7, Vista, 2003, XP, and 2000 operating systems.
Resource Taken From :- http://quizilla.teennick.com/stories/16148801/unexpected-error-in-access-2002-2003-and-2007
