[AccessD] Relationships to Visio?

John Bartow john at winhaven.net
Wed Sep 24 10:19:11 CDT 2008


Hi Rocky,
It depends what your goal is.

With the correct version of Visio (2002/2003 Pro) you can layout a complete
database with relationships and then create it in Access from the Visio
diagram. 

If you already have a database and just want to show the tables and
relationships for documentation then you could create it in any version of
Visio as a standalone document. This is quite simple to do. You may be able
to import the database structure from Access with the Visio standard version
but I'm not sure. 

I like using Visio diagrams for db documentation purpose because I can color
code the tables (or use lines and shapes) to enhance the visual impact of
the layout. Grouping tables for their general purpose by color while showing
the inter-connectedness of the complete data set tends to help non-database
types with understanding it.

This article may help:
http://msdn.microsoft.com/en-us/library/aa662937.aspx

HTH
John B.




More information about the AccessD mailing list