Microsoft KB Archive/827231

= Five is the maximum number that you can use for the primary key when you link shapes to a database table in Visio 2007 or in Visio 2003 =

Article ID: 827231

Article Last Modified on 11/11/2006

-

APPLIES TO


 * Microsoft Office Visio Professional 2007
 * Microsoft Office Visio Standard 2007
 * Microsoft Office Visio Professional 2003
 * Microsoft Office Visio Standard 2003

-





SUMMARY
This article discusses the number of primary key fields that you can configure when you use the Database Wizard to link shapes in your Microsoft Office Visio 2007 or Microsoft Office Visio 2003 drawing to records in a database table.

When you use the Database Wizard to link shapes in your Visio drawing to records in a database table, the maximum number of fields that you can use as the primary key for a database table is five.



MORE INFORMATION
The primary key is the field or the combination of fields that uniquely identifies each record in a database table. You can select from one to five fields in the Number of fields box when you configure the primary key for the database table that you want to link to.

To use the Database Wizard in Visio to link shapes in your drawing to a database, follow these steps:
 * 1) Start Visio and open your drawing.
 * 2) Select the shapes that you want to link to the database.
 * 3) On the Tools menu, point to Add-Ons, point to Visio Extras, and then click Database Wizard.

The Database Wizard starts.
 * 1) Click Next.

Follow the instructions in the remaining pages of the Database Wizard to link the shapes to the database.

For more information about Visio, visit the following Microsoft Web site:

http://www.microsoft.com/office/visio

Additional query words: VSO2007 VISIO2003

Keywords: kbprb KB827231

-

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

© Microsoft Corporation. All rights reserved.