William Hindman
wdhindman at dejpolsystems.com
Wed Mar 11 12:21:37 CDT 2009
...dl the Visio 2007 60 day trial ...imnsho, one of the few things in the Office 2007 line worth the upgrade over 2003. William -------------------------------------------------- From: "Rocky Smolin at Beach Access Software" <rockysmolin at bchacc.com> Sent: Wednesday, March 11, 2009 11:32 AM To: "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com> Subject: Re: [AccessD] From a reader > Thanks. I'll give it a try. > > > 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: Wednesday, March 11, 2009 8:20 AM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] From a reader > > 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 > > -- > 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 >