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
* To learn how to fix this reference, click Help.
Error message 2
Can't find project or
Your database contains a reference to a database, type
library, or object library that is marked as MISSING: <referencename>
in the References
To remove the missing reference, follow these steps:
- Open your database.
- Press ALT+F11 to open the Visual Basic Editor.
- On the Tools menu, click References.
- Click to clear the check box for the type library or object
library marked as MISSING: <referencename>.
An alternative to removing the reference is to restore the
referenced file to the path that is specified in the References
dialog box. If the referenced file is in a new location, clear
the MISSING: <referencename>
reference, and then create a new reference to the file in the new
: In an Access run-time application, you cannot view references
from a menu. However, the following article demonstrates how to view references
How to loop through references to view their properties
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:
"Undefined function in expression" error message when you open
a query that references a function
Article ID: 283806 - Last Review: April 15, 2013 - Revision: 5.5
- Microsoft Access 2002 Standard Edition
- Microsoft Excel 2002 Standard Edition
- Microsoft Word 2002
- Microsoft Office Access 2003
- Microsoft Office Access 2007
- Microsoft Access 2010
|kbproductlink kbfunctions kbvba kberrmsg kbprb KB283806|