ACC97: Database Documenter Displays GUID Instead of Relationship Name (262009)


The information in this article applies to:

  • Microsoft Access 97
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.
Modification Type:MajorLast Reviewed:9/25/2003
Keywords:kbprb KB262009
©2003 Microsoft Corporation. All rights reserved.