Microsoft KB Archive/246169

= ACC97: MDE Database Must Be Recompiled Under Current Service Release =

Article ID: 246169

Article Last Modified on 1/25/2007

-

APPLIES TO


 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q246169



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



SYMPTOMS
When you are working with a Microsoft Access 97 MDE database, you may receive one or more of the following errors:


 * ActiveX can't create object.
 * Function name  in expression not found.
 * Function isn't available in expressions in query expression.
 * Compile error.



CAUSE
The database may have been compiled into the MDE file type on a computer that does not have the same service release for Access 97 as the development computer. The problem is generally caused by one of two things:
 * 1) The database includes a reference to the utility database, Utility.mda.
 * 2) The MDE database was compiled using libraries (DLL, OCX, etc.) that have been modified between service releases.



Resolution for Cause 1
On the development computer, ensure that you have installed the latest service release, and then in the original MDB database:
 * 1) Open a module in Design view, click References on the Tools Menu, and then click to clear the reference to Utility.mda.
 * 2) On the Debug menu, point to Compile and Save All Modules.
 * 3) Close the module.
 * 4) On the Tools menu, point to Database Utilities, and then click Make MDE file.
 * 5) Redistribute the MDE database, ensuring that all target computers have the same service release installed.

Resolution for Cause 2
On the development computer, ensure that you have installed the newest version of all libraries that are referenced and used in your environment, and then:
 * 1) In the original MDB database, open any module in Design view.
 * 2) On the Debug menu, point to Compile and Save All Modules.
 * 3) Close the module.
 * 4) On the Tools menu, point to Database Utilities, and then click Make MDE file.
 * 5) Redistribute the MDE database, ensuring that all target computers receive updates to all referenced libraries.

Additional query words: prb sr-1 sr-2 ActiveX can t create object function isn available in expressions query expression

Keywords: kbprb KB246169

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.