Article ID: 283806 - View products that this article applies to.
This article was previously published under Q283806
Moderate: Requires basic macro, coding, and interoperability skills.
This article applies to a Microsoft Access database (.mdb and .accdb) and to a Microsoft Access project (.adp).
For a Microsoft Access 2000 version of this article, see 208218
For a Microsoft Access 97 version of this article, see 160870
If you have a procedure that contains a Visual Basic for Applications function and your database contains a reference to a missing object library or type library, you may receive one of the following error messages when you compile your modules or run the procedure:
Error message 1
Your Microsoft Access database or project contains a missing or broken reference to the file <filename>.
* To ensure that your database or project works properly, you must fix this reference.
* To learn how to fix this reference, click Help.
Error message 2
Can't find project or library
Your database contains a reference to a database, type library, or object library that is marked as MISSING: <referencename> in the References dialog box.
To remove the missing reference, follow these steps:
NOTE: In an Access run-time application, you cannot view references from a menu. However, the following article demonstrates how to view references using code:
(https://support.microsoft.com/kb/209849/ )How to loop through references to view their properties
Steps to Reproduce the Behavior
For additional information about another problem that could cause the first error message, click the following article number to view the article in the Microsoft Knowledge Base:
(https://support.microsoft.com/kb/275110/ )"Undefined function in expression" error message when you open a query that references a function
Article ID: 283806 - Last Review: July 12, 2013 - Revision: 5.6