Microsoft KB Archive/96107

{|
 * width="100%"|

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

 * }

Q96107

-

The information in this article applies to:


 * Microsoft Access versions 1.0, 1.1

-

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

Issue type : kbprb

Technology :