ACC2000: Corrupted VBA Project Error When You Try to Convert a Database (225946)


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q225946
Novice: Requires knowledge of the user interface on single-user computers.

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

For a Microsoft Access 2002 version of this article, see 294755.

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

In most cases, this problem is resolved by Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a). To obtain SR-1/SR-1a, click the article number below to view the article in the Microsoft Knowledge Base:

245025 OFF2000: How to Obtain and Install Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a)

If SR-1/SR-1a does not resolve this problem for your particular database, use one of the following workarounds.

Method 1: Compact in Access 97

  1. Open the database that is in the earlier version of Access.
  2. Open any module in Design view.
  3. On the Debug menu, click Compile and Save All Modules.
  4. Close the database.
  5. On the Tools menu, point to Database Utilities, and then click Compact Database.
  6. Convert the database again in Access 2000.
NOTE: If you want to use this method, but 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 in Method 1.

    -or-

  • Reinstall Access 97 on your computer.

    If you reinstall Access 97, make sure you install Access 97 in a folder different from the folder where you have Office 2000 installed. This may require you to change the default installation location during Setup of Access 97.

Method 2: Import the Objects Directly

  1. Start Microsoft Access 2000.
  2. Create a new, blank database.
  3. On the File menu, point to Get External Data, and then click Import.
  4. Select the database that you want to convert to Access 2000, and then click Import.
  5. Select all the objects on each tab of the Import dialog box.
  6. Click the Options button.
  7. Select the options to import Relationships, Menus and Toolbars, and Import/Export Specs.
  8. Click OK to perform the import.
Note that you must add any references that your VBA project requires by clicking References on the Tools menu in the Visual Basic Editor.

Method 3: Remove References to Utility.mda

  1. Open the database that is in the earlier version of Access.
  2. Open any module in Design view.
  3. On the Tools menu, click References.
  4. Click to clear the Utility check box, and then click OK.
  5. On the Debug menu, click Compile All Modules.
  6. Close the database.
  7. Convert the database again in Access 2000.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was corrected in Microsoft Office 2000 SR-1/SR-1a.

REFERENCES

For more information about conversion issues, 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, click the article number below to view the article in the Microsoft Knowledge Base:

209137 ACC: How to Repair a Damaged Database

For additional information about problems you may encounter when you try convert a database from an earlier version of Microsoft Access, click the article number below to view the article in the Microsoft Knowledge Base:

224340 Error Message: There Were Compilation Errors During the Conversion or Enabling Of This Database...

Modification Type:MajorLast Reviewed:11/4/2002
Keywords:kbbug kberrmsg KB225946
©2002 Microsoft Corporation. All rights reserved.