Microsoft KB Archive/262009

= ACC97: Database Documenter Displays GUID Instead of Relationship Name =

Article ID: 262009

Article Last Modified on 1/27/2007

-

APPLIES TO


 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q262009



Novice: Requires knowledge of the user interface on single-user computers.



SYMPTOMS
In the report that is generated by Database Documenter, a globally unique identifier (GUID) is displayed instead of a friendly name for a relationship. This behavior occurs only on those relationships that have been imported from another database. Relationship names appear as expected for relationships created within the current database.



CAUSE
Relationship names are stored in a system table in a database. When importing objects from another database, Microsoft Access does not import the system tables. Therefore, a GUID is generated for the name of each relationship that is imported.



MORE INFORMATION
This behavior does not occur in Microsoft Access 2000.

Steps to Reproduce the Behavior

 * 1) Create a new database.
 * 2) On the File menu, point to Get External Data, and then click Import.
 * 3) Browse to the sample database Northwind.mdb, and then click Import.
 * 4) In the Import Objects dialog box, click the Tables tab, and then click Select All. Click Options, and then click to select the Relationships check box. Click OK.
 * 5) After the tables and relationships have been imported, on the Tools menu, point to Analyze, and then click Documenter.
 * 6) In the Documenter dialog box, click the Tables tab, and then click Select All. Click OK.
 * 7) Note that in the report that the Database Documenter generates, the relationship names are listed as GUIDs.

Additional query words: prb characters index msysrelationships

Keywords: kbprb KB262009

-

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

© Microsoft Corporation. All rights reserved.