subject: Error Message While Compiling Ms Access Database [print this page] There can be numerous causes for an occurrence of an error message in MS Access database. These error messages can occur during the compilation stage, mounting stage, or while performing some changes in the database. While the error messages can occur at various stages, the outcome for most of error messages is inaccessibility of records stored in the database. To overcome the hazards created by the error messages, a perfect way is to restore the data from an updated backup. However, if the database backup is deleted, corrupted, or inaccessible, then you will need to opt for powerful mdb repairsoftware that provides complete access to your database records.
Consider a practical case, where you receive any of the below error messages when you attempt to compile your Access database or attempt to view the code for a module:
Error accessing file. Network connection may have been lost.
Or
"This action will reset the current code in break mode.
Do you want to stop running code?
To halt the execution of the program so the Module window can be closed, select Yes.
To leave the code in the current state, select No.
Cause
Both the above error messages occur when both MS Access 2000 and version 6.3.91.8 of the Vbe6.dll file are installed on your system, and one of the two below condition is true:
You imported report(s) or form(s) which include standalone modules into a new Microsoft Access 2000 database using MS Access 2000.
You copied and pasted report(s) and form(s) which include standalone modules into a new Microsoft Access 2000 database using MS Access 2000.
Resolution
To resolve the above error message and access the database records, you will need to follow the below steps:
You will need to create a new database and import all the components into it.
Now, open Visual Basic Editor and click Compile.
Close and save the database.
In case the above steps fail to resolve your problem, then you will need to use advance third party Access Database Repair tool. These repair mdb tools use high end scanning methods to repair the corrupted database and provide easy access to all database components.
Stellar Phoenix Access Recovery is a comprehensive solution to repair all corrupt MS Access databases and recover it components (modules, tables, forms, and reports). The read only Access Repair software provides safe database repair and supports Microsoft Access 2007, 2003, XP (2002), and 2000.
