ACC2000: References Dialog Box Displays an Unexpected Name When You Reference Another Database (200203)


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q200203
This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

Moderate: Requires basic macro, coding, and interoperability skills.

SYMPTOMS

When you browse to an .ade, .adp, .mda, .mdb, or .mde file in the Add References dialog box and set a reference to one of these databases, the name that appears in the References dialog box differs from the actual file name that you selected in the Add References dialog box.

CAUSE

The project name of the referenced database is displayed instead of its actual file name.

STATUS

This behavior is by design.

MORE INFORMATION

If one Microsoft Access database references another Microsoft Access database, the project name of the database is displayed in the References dialog box rather than its actual file name.

Steps to Reproduce the Behavior

  1. Create a new Microsoft Access database named Db1.mdb in the C:\Program Files\Microsoft Office\Office\Samples folder.
  2. In the Database window, click Modules under Objects, and then click New.
  3. On the Tools menu, click Db1 Properties. In the Db1 - Project Properties dialog box, change Project Name to MyProject, and then click OK.
  4. Close the Visual Basic Editor and close Db1.mdb, but stay in Access. If you are prompted to save the module, click No.
  5. Open the sample database Northwind.mdb, and then open the Utility Functions module in Design view.
  6. On the Tools menu, click References.
  7. In the Add References dialog box, click Browse, and then add a reference to Db1.mdb. Note that it appears in the References dialog box as MyProject.
  8. Click OK to close the References dialog box, and then quit Microsoft Access.
  9. Move Db1.mdb to the C:\My Documents folder.
  10. Open the sample database Northwind.mdb and check the References dialog box. Note that it now displays MISSING: Db1.mdb, the actual file name.
Modification Type:MajorLast Reviewed:6/24/2004
Keywords:kbprb kbusage KB200203
©2004 Microsoft Corporation. All rights reserved.