ACC97: MDE Database Must Be Recompiled Under Current Service Release
ID: Q246169
|
The information in this article applies to:
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 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:
- 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.
RESOLUTIONResolution 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
Keywords : kbdta ocsso
Version : WINDOWS:97
Platform : WINDOWS
Issue type : kbprb
|