office 97

SYMPTOMS:
Moderate: Requires basic macro, coding, and interoperability skills.

When you run a custom application that you created with the Microsoft Office 97 Developer Edition Tools or the Microsoft Access Developer's Toolkit, you receive a compile error. The same application runs correctly when you run it with the retail version of Microsoft Access.

CAUSE:
This compile error will occur in Microsoft Access 97 or Microsoft Access for Windows 95 version 7.0 if your application uses methods or properties in a referenced database that has not been included in the application distribution set or if Microsoft Access cannot establish a valid reference. (Wizards in Microsoft Access 97 and in Microsoft Access 7.0 are shipped in a compiled state and cannot be referenced.)

A similar error can occur in Microsoft Access version 2.0 if you make a reference in your application's code to functions or variables defined in the WZLIB.MDA file (which cannot be legally distributed with your application), or to any other library database that is not loaded in your application.

RESOLUTION:
Remove or modify the code in your application that refers to the WZLIB.MDA file, or to any other file that is not referenced (in Microsoft Access 97 and 7.0) or not loaded (in version 2.0).

Source of information:
Microsoft article Q119754 "Compile Error When Running ADT or ODE Application"

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q119754

(REMOVE SPACES from the pasted URL.)

See that article for more information on the problem.

Maxwell