ACC2000: Corrupted VBA Project Error While Converting Database

ID: Q225946

The information in this article applies to:

Microsoft Access 2000

Novice: Requires knowledge of the user interface on single-user computers.

This article applies only to a Microsoft Access database (.mdb).

SYMPTOMS

When you try to convert a database to Access 2000, you may receive the following error message

An error occurred while loading Form_FormName. Do you want to continue...

followed by a second message:

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

CAUSE

You receive these error messages when the database that you are trying to convert is not in a compiled state, or if there was corruption in the database before you tried to convert it to Microsoft Access 2000.

RESOLUTION

To correct the behavior, follow these steps.

Open the database that is in the earlier version of Access.

Open any module in Design View.

On the Debug menu, click Compile and Save All Modules.

Close the Database.

On the Tools menu, point to Database Utilities, and then click Compact Database.

Convert the database again in Access 2000

NOTE: If you have already removed Access 97 from you computer you have two options:

Move the database to a computer that still has Access 97 installed and follow the steps listed above.

-or-
Install Access 97 back onto your computer.

Make sure to install Access 97 to a different directory than that of Office 2000. This may require you to change the default install location during setup of Access 97.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

REFERENCES

For more information about conversion, click Microsoft Access Help on the Help menu, type "Convert a database" in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

For additional information about corrupted databases, please see the following article in the Microsoft Knowledge Base:

Q209137 ACC: How to Repair a Damaged Database

Additional query words:


Keywords          : kbdta CnvErrs CnvGnrl CnvProb 
Version           : WINDOWS:2000
Platform          : WINDOWS 
Issue type        : kbbug

Last Reviewed: July 12, 1999