This step-by-step article describes how to link shape data in a Microsoft Visio drawing to a Microsoft SQL Server 2000 database.
If you establish connections between shapes and database records, you can create Visio drawings that function as visual representations of data. After you establish a shape-record connection, you can create new shapes from database records, synchronize the data in your Visio drawing with the database, and, if you have write-access rights to the database, update the database from your Visio drawing.
Every Visio shape is described in its own ShapeSheet spreadsheet, which contains information about the shape's geometry and its other properties. If you link a shape to a database, you actually link cells in the shape's ShapeSheet spreadsheet to fields in a database table. Typically, you link a shape's custom properties to database fields.
For more information about how to link Visio shapes and drawings to a database, type linking shapes to databases in the Ask a question box or the Answer Wizard, and then press ENTER to view the topics.
For additional information about how to use Visio, click the article number below to view the article in the Microsoft Knowledge Base:
281273 Visio: Online Resources for Books, Training, Tips, Updates, Development, Solution Providers, and Support