Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

ACC2000: An MDE File That References Another MDE File Cannot Run Code After Both Are Moved to Another Folder


View products that 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).

↑ Back to the top


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.

↑ Back to the top


Cause

After creating the MDE files, you moved them to another folder.

↑ Back to the top


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.

↑ Back to the top


Status

Microsoft 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.

↑ Back to the top


Keywords: KB248895, kbfix, kbbug

↑ Back to the top

Article Info
Article ID : 248895
Revision : 2
Created on : 6/26/2006
Published on : 6/26/2006
Exists online : False
Views : 336