[AccessD] Relationships to Visio?

That's because Visio leaves the layout up to you.  It just jams it all
in and lets you put the cosmetic touches on.

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
at Beach Access Software
Sent: Wednesday, September 24, 2008 9:14 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [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

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