While working with MS Access, you never know what problem will come in your way to performing any task. Error messages appear on your computer screen without giving any clue and make you spend hours and hours on finding out the solution. Below mentioned is one of such errors that frustrate you badly:
â€œThe Visual Basic for Applications project in the database is corrupt.â€
This error occurs when you convert any MS Access 97 database to MS Access 2000 format and the database contains several hundred forms. If even after occurrence of this error, database gets successfully converted, no module will be displayed in the project.
How to confirm the cause of the issue?
To make sure that the error is occurred because the database contains several hundred forms, follow these steps:
Create a new blank database in Access 97 and name it ManyForms.mdb.
In the new database, click Modules under Objects, and then click New.
Type the code to create 900 forms, each with the HasModule property set to Yes
On the View menu, click Debug Window
In the Debug window, type the following line, and then press ENTER: CreateManyForms
Close the module and don’t save the changes
Close the database and quit Access 97
Open Access 2000
On the File menu, click Open.
Locate the ManyForms.mdb and open it
When prompted, click Convert Database, and then click OK
During conversion, you receive the following message
â€œThe Visual Basic for Applications project in the database is corruptâ€
If the conversion process creates the new database, open any form in Design view.
On the View menu, click Code. If you see that no module is opening, then it is for sure that the error is caused due to hundreds of forms in database.
Resolving the issue:
Now that the cause of the issue is confirmed, you can move further to resolve it. To resolve this issue:
Open your original database in Access 97 and delete any forms that you do not need.
Move some of the forms to another Access database before you convert the database.
Continue deleting or moving forms out of the database until you no longer receive the error.
If there is any form with a blank or unused module, set the HasModule property of the form to No.
Now convert the database. You will face no error and also be able to see modules in converted database.
Free download demo version of kernel for access recovery software.