Q225949 ACC2000: Error Converting a Database with a Large Number of Forms That Have Modules.

Symptoms

If the Access 97 database contains hundreds of forms you may get the following error when you attempt to convert the database to Access 2000:

”The Visual Basic for Applications project in the database is corrupt. “

If the database is converted successfully you will not be allowed to view any of the modules in the project.

Cause

The database (Access 97) has hundreds of forms each of which has a VBA module.

Resolution

Open the original database in Access 97 deleting any surplus forms. You can also move some forms to another database before you attempt to convert it. Keep moving or deleting forms from the database and eventually the error will cease.
Another measure to take is to check if any of the forms have blank or unused modules. If they do, set the ‘HasModule’ property to ‘No’.