subject: Repairing Corrupted Access 2000 Database When Using Vba Codes [print this page] MS Access is a relational database management system (RDBMS) from the MS Office product suite. It is used to create simple databases using the Microsoft Jet Database Engine combined with a rich user interface and related development tools. In addition, the advanced Access users can use Visual Basic for Applications (VBA) language to create rich solutions with advanced data manipulation and user control techniques. However, sometimes the applications created using VBA codes may get corrupted. In such cases, you should use appropriate corrective measures to rectify the problem. However, if you are unable to solve the issue then you should use a third-party Access repair software to repair the Access file.
Consider a scenario wherein you have created an interactive utility in MS Access 2000 using VBA codes. When you press Alt + F11 to edit the application, it fails to open. An error message is displayed, that is:
The module name 'module name' is misspelled or refers to a module that doesn't exist.
If the invalid module name is in a macro, an Action Failed dialog box will display the macro name and the macro's arguments after you click OK. Open the Macro window, and type the correct module name.
Cause:
The root cause of this error message is that the Access database is corrupt. It would have corrupted because of various reasons such as virus infections, power outages, corrupted MS Office, abrupt system shutdown, etc.
Resolution:
To resolve this error message and to be able to use the database again, you need to copy the contents of the table into a new table. To do this, you should perform the following steps:
Create a blank database.
Open the corrupted database, and then click Tables under Objects.
Right-click the first table, and then click Export on the shortcut menu.
In the Export to dialog box, browse and click the newly created database.
Click OK. Repeat steps 4 through 6 for each table, query, and macro.
Using the aforementioned steps, you will be able to create a new database and transfer the data in a new database. Check the database and see if it is still displaying the same error message. If yes, then you need to use a third-party Access database repair software to repair Access file. Such read-only tools are able to repair the corrupted databases by using fast yet sophisticated scanning algorithms.
