ACC1x: Compile Error When You Attempt to Use a MS Access Wizard

ID: Q96107

The information in this article applies to:

SYMPTOMS

When you try to use a Microsoft Access Wizard, you may receive the following error message:

Compile error


CAUSE

This occurs because there is a compile error in the code stored in the database.

Microsoft Access must compile all code in memory to use any of it. This includes the code stored in the database and any libraries (.MDA files) that are loaded. When you attempt to use a Microsoft Access Wizard, Microsoft Access must compile the Access Basic code that is in the WIZARD.MDA file in addition to any code in your database. If there is an error in the code in your database, Microsoft Access will not be able to run the wizard because the compilation failed.


RESOLUTION

To resolve this behavior, follow these steps:

  1. Open your database.


  2. Open any module in Design view.


  3. Choose Compile All from the Run menu.


Microsoft Access will bring up the module window with the offending line of code. Upon correcting the error, and assuming there are no other errors, the wizards should work correctly.

If the Compile error message persists, repeat steps 2 and 3 until all errors in the code are corrected. 


Keywords          : kberrmsg kbprg MdlGnrl 
Version           : 1.0 1.1
Platform          : WINDOWS 
Issue type        : kbprb

Last Reviewed: March 19, 1999