What could be more disastrous than receiving an error message while attempting to mount your Access database? Unmountability of the access database primarily results into inaccessibility of all its stored records. The most obvious reason for the occurrence of the error message could be corruption of Access file. Damage in the file can be caused due to various reasons, such as improper system shutdown, application malfunction, malicious software, simultaneous modification of same database records. All the hazards created after the error message can be easily surmounted by restoring the records from an updated database backup. However, unavailability of an updated backup does not leaves you with any other option, but to use an advanced Access Database Repair utility.

Consider a practical case, where you receive the below error message while attempting to open an MS Access database file:

"Microsoft Office Access was unable to open the file '|'. The file may not be an Access file, the path or filename specified may be incorrect, or the file can not be opened exclusively. To repair the file manually, on the File menu, point to Manage Database, and then click Compact and Repair Database"

As the file could not be opened, the records stored in it becomes inaccessible. In addition, the error message appears repeatedly every time you attempt to open the Access file.

Cause
Corruption of Access database file.

Resolution
An easy solution (as suggested in the above error message) is to Compact and Repair the database. To do so, follow the underneath steps:

1. Go to Toolbar menu and click 'Tools'
2. In the drop down list, choose 'Database Utilities' and click 'Compact and Repair Database'.
3. Choose Access file that needs to be repaired in 'Database to Compact From'.
4. The compact and repair process can be started by clicking on 'Compact'.
5. Select a destination where you will need to save the database file.
6. Click 'Save'.

The resolution suggested in the error message repairs your database in most cases. However, if the resolution is unable to accomplish the desired results, then you will need to use advanced repair mdb tools to repair your damaged database file. Such third-party Access Repair applications use advanced scanning methods to repair the corrupt database file.

Access Recovery is a reliable mdb repair tool used world-wide by both technical and non-technical users. The tool is easy to understand without any prior technical understanding. It supports Access 2007, 2003, XP (2002), and 2000. The repair tool is compatible with Windows 7, Vista, 2003, XP, and 2000.

Article Source: http://EzineArticles.com/?expert=Anurita_Singh
http://EzineArticles.com/?Repair-MS-Access-Database-File&id=3622015