ACC2000: An MDE File That References Another MDE File Cannot Run Code After Both Are Moved to Another Folder (248895)
The information in this article applies to:
This article was previously published under Q248895 Advanced: Requires expert coding, interoperability, and multiuser skills.
This article applies only to a Microsoft Access database (.mdb).
SYMPTOMS
When you try to run an event procedure in an Access MDE file that references a function in another Access MDE file, you may receive the following error message:
The expression <expression type> you entered as the event property setting produced the following error: Requested type library or wizard is not a VBA project.
*The expression may not result in the name of a macro, the name of a user-defined function, or [Event Procedure].
* There may have been an error evaluating the function, event, or macro.
CAUSE
After creating the MDE files, you moved them to another folder.
RESOLUTION
To resolve this problem, obtain Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a).
To obtain SR-1/SR-1a, click the article number below to view the article in the Microsoft Knowledge Base:
245025 OFF2000: How to Obtain and Install Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a)
To temporarily work around this problem, move the MDE files back to the original location or create new MDE files in the new folder.
Office 2000 SR-1 only enables the MDE to resolve references the same way an Access database (MDB) does. This means it will search for the new location of the reference in specific folders. If the referenced file is in a folder that is not searched, the reference remains broken. To resolve this, you can either move the file to a folder that will be searched, or you can use the RefLibPaths key to include additional paths where Microsoft Access can search for broken references.
STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
This problem was corrected in Microsoft Office 2000 SR-1/SR-1a.
| Modification Type: | Minor | Last Reviewed: | 6/26/2006 |
|---|
| Keywords: | kbbug kbfix KB248895 |
|---|
|