Charlotte Foust
cfoust at infostatsystems.com
Wed Mar 11 10:19:31 CDT 2009
Depends on the version you have, Rocky. There is a learning curve, but I started with Visio 1, long before MS bought it, so I don't really know how steep it would be starting with a late version. It has the capability of importing a database schema from an mdb and it allows you to specify items to include/exclude. It only works with an unsecured database and I don't know if it handles anything but an mdb these days because I'm not actively using it. Once you have imported the schema, you can create pages and put tables and their relationships on whichever page you want in order to group them. You can save the resulting diagram to html, among other formats, so it can be viewed in a browser without Visio involved at all after that. 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, March 11, 2009 7:58 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] From a reader Charlotte: I've never used Visio because I've not had a need for it - looked at it once and seemed to have a bit of a learning curve - but I have a copy. And have occasionally wished I could print a nicer relationships diagram. Is it easy to get Visio to do this? 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 Charlotte Foust Sent: Tuesday, March 10, 2009 1:59 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] From a reader Sounds like they wind up tripping over the maximum number of objects on an Access report, Susan. They must have gone hog wild on relationships! Making the relationships smaller would mean removing some of the tables (not the relationships) from the layout and printing it a piece at a time. If you don't remove the relationships, they remain, they just aren't visible in the layout at a given time. You can always use show all to see all the tables and start removing them again to get down to another layout. Unfortunately, there's no way to save more than one layout, but you could capture the preview to a pdf file for later, I guess. If they want one huge diagram, they're going to have to look to a 3rd party tool that can reverse engineer the relationships and schema from the database file. DeZign for Databases is a tool I used to use, among others. Visio was my favorite for years, but MS priced the useful versions out of the market for me. DeZign is reasonably priced but doesn't produce layouts that look as pretty. Charlotte Foust -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins Sent: Tuesday, March 10, 2009 1:51 PM To: AccessD at databaseadvisors.com Subject: [AccessD] From a reader The relationships have grown large enough that Access won't print them. I've never run into this, but would be interested in a solution if you know of one. I think the error is a bit peculiar as I don't understand how making the layout smaller would help -- not really sure what that even means! Thanks! Susan H. "We've created a significant database using Microsoft Office Access (works in both 2003 and 2007). Over the years the relationships have become more complex. We would like to be able to print a large format report (11" x 17") or to segment the report into pages we can manually tape together. Currently when we try we get: ------------------------------------------------ Print Relationships Error Box i The Relationships window layout is too large to fit in a Microsoft Office Access report. Some of the tables and/or relationship lines will not show up in your report. To print all relationships, make the layout smaller and run the wizard again. ------------------------------------------------- Do you know of a method to allow us to overcome this limit or perhaps a 3rd party tool that can help us?" -- 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com