[AccessD] Relationships to Visio?

Well, the import into Visio turned out to be easy  but the diagram was not
as good as the Access relationships layout.


Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com
www.bchacc.com
 
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Bartow
Sent: Wednesday, September 24, 2008 8:19 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Relationships to Visio?

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.

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com