database contains a reference to the database, to the type library, or to the object
library that is marked as missing in the MISSING:
ReferenceName check box. This check box appears in the References
When you open a database in Access 2007 or in Access 2003, you are informed
about any problems with referencing external libraries and projects. When the
database has a broken reference to a library or to a project at the time that you try
to run a query that calls a function, you receive the first error message that is mentioned in the "Symptoms" section. When you click
OK, you receive the second error message that is mentioned in the "Symptoms" section.
You receive the first error message one time. If you have other queries that
have calls to functions, you receive only the second error message when you run the other queries. This behavior occurs until you close and then reopen the
Caution If you follow the steps in this sample, you modify the
Northwind sample database. You must back up the
Northwind sample database, and then follow
these steps on a copy of the Northwind sample database.
Steps to reproduce the problem
Create a new blank database in Access.
Close the database that you created in step 1, and then open the Northwind sample database.
Use the following Microsoft SQL statements to create two new queries in the
Northwind sample database.
SELECT CustomerID, CompanyName, ContactName, ContactTitle, Trim([City])
& ", " & Trim([Region]) & " " & Trim([PostalCode]) AS CoAddress FROM
Save this query as QryTest.
SELECT CustomerID, Left([CompanyName],4) AS ShortName FROM Customers;
Save this query as QryTest2.
On the View menu, point to
Database Objects, and then click
Note If you use Access 2007, click Supporting Objects in the left pane.
Open the Utility Functions module in
Note In Access 2007, double-click the Utilities module.
On the Tools menu in the Visual Basic Editor, click
In the References - Northwind dialog box,
Select Microsoft Access Databases (*.mdb)
in the Files of type list, and then locate the folder where
you put the database that you created in step 1.
Note In Access 2007, select Microsoft Access Databases (*.accdb) in the Files of type list, and then locate the folder where
you put the database that you create in step 1.
Click the database that you created in step 1, and then click
References dialog box, click OK, and then exit Access.
Open Windows Explorer, locate the folder where
you put the database that you create in step 1, and then delete the database.
Reopen the Northwind sample database, and then try to open the QryTest
query or the QryTest2 query. Notice that the following behavior occurs:
In Access 2007, you receive one of the following error messages:
Error message 1
Your Microsoft Access database or project contains a missing or
broken reference to the file FileName.
Error message 2
To ensure that your
database or project works properly, you must fix this reference.
In Access 2003, you receive the following
FunctionName in expression.
If you are using Access 2007, notice that you receive the following