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:
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:
- The database includes a reference to the utility database, Utility.mda.
- The MDE database was compiled using libraries (DLL, OCX, etc.) that have been modified between service releases.
RESOLUTION
Resolution for Cause 1
On the development computer, ensure that you have installed the latest service release, and then in the original MDB database:
- Open a module in Design view, click References on the Tools Menu, and then click to clear the reference to Utility.mda.
- On the Debug menu, point to Compile and Save All Modules.
- Close the module.
- On the Tools menu, point to Database Utilities, and then click Make MDE file.
- 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:
- In the original MDB database, open any module in Design view.
- On the Debug menu, point to Compile and Save All Modules.
- Close the module.
- On the Tools menu, point to Database Utilities, and then click Make MDE file.
- 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