Article ID: 275110 - View products that this article applies to.
This article was previously published under Q275110
For a Microsoft Office Access 2003 version of this article, see 824277Moderate: Requires basic macro, coding, and interoperability skills.
This article applies only to a Microsoft Access database (.mdb).
When you try to open a query that contains a function, you receive both of the following error messages. When you open any subsequent query, you receive only the second error.
when you click OK to the first error message, you receive a second message:
Your Microsoft Access database or project contains a missing or broken reference to the file '<FileName>'.
Undefined function '<FunctionName>' in expression.
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:
When you open a database in Microsoft Access 2002, you are informed about any problems with referencing external libraries and projects. When the database contains a broken reference to a library or project at the time that you try to run a query that calls a function, Access 2002 displays the first message that is mentioned in the "Symptoms" section of this article. After you click OK to this message, you immediately receive the second message that is mentioned in the "Symptoms" section of this article.
After you receive the first message, the first message is not displayed again. Even if you have other queries that contain calls to functions, these other queries only return the second message until you close the database and then reopened it.
CAUTION: If you follow the steps in this example, you modify the sample database Northwind.mdb. You may want to back up the Northwind.mdb file and follow these steps on a copy of the database.
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:
(http://support.microsoft.com/kb/283806/ )Visual Basic for Applications (VBA) functions break in a database with missing references