Microsoft KB Archive/248895

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 08:43, 21 July 2020 by X010 (talk | contribs) (Text replacement - ">" to ">")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Knowledge Base


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

Article ID: 248895

Article Last Modified on 6/26/2006



APPLIES TO

  • Microsoft Access 2000 Standard Edition



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.

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.


Additional query words: pra directory

Keywords: kbbug kbfix KB248895