Microsoft KB Archive/200203

= ACC2000: References Dialog Box Displays an Unexpected Name When You Reference Another Database =

Article ID: 200203

Article Last Modified on 6/24/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



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.

Additional query words: prb different another refers

Keywords: kbprb kbusage KB200203

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.