Rectifying "Program crashes..." Error Message in MS Access

An error message while mounting Microsoft Access database primarily occurs because of damage or corruption of database. Few main reasons responsible for the corruption of database are unexpected system shutdown, MS Office malfunctioning, concurrent modification by two or more users on the same database object, malicious software like virus and more. Data stored in the database components becomes inaccessible after it gets corrupted due to any of the above reasons. An ideal solution to overcome these situations is by restoring the data from an updated backup. However, in case of absence of an updated backup, you will need to repair the database by using powerful access repair application.

Consider a practical instance, where you encounter the below error message when you attempt to mount an Access database named Employee:

“Program crashes with error message 'Invalid Page Fault/GPF' when opening the mdb file”

All the records stored in the Employee database become inaccessible after the above error message appears. In addition, you receive the same error message each time you attempt to mount the Employee database.

Cause:

The root cause for the occurrence of the above error message is the corruption of Employee database.

Resolution:

To access the data stored in the Employee database, you will need to use the inbuilt repair utility named “Compact and Repair.” To do so, you will need to take these steps:

1. Go to the Tools menu, select Database Utilities and then click Compact and Repair Database. 2. Locate and then click the database in the ‘Database to Compact From’ dialog box, and then click Compact. 3. Select an appropriate folder location for the new file in the ‘Compact Database Into’ dialog box, type a unique name for the file and then click on Save.

While “Compact and Repair” repairs your database in most of the cases, but the utility fails to repair databases if there are severely corrupted. In such circumstances, the best option available is to use powerful Access Repair application. Such Access Database Repair applications use high end scanning mechanisms to comprehensively scan and repair your damaged database. Built with highly graphical user interface, automated repair procedure, these utilities serve as self-explanatory and repair centric tools.

Stellar Phoenix access recovery is the finest Access Database Repair application. This non destructive utility can restore and Repair Access database components like queries, forms, reports, macros and modules. The software supports Microsoft Access 2007, 2003, 2002 (XP) and 2000. It is designed for Windows Vista, XP, 2003, 2000 and NT.