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.