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

 Last reviewed: June 8, 1997
Article ID: 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 MdlGnrl PgmOthr
Version : 1.0 1.1
Platform : WINDOWS
Hardware : X86
Issue type : kbprb
Resolution Type : kbworkaround

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: June 8, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.