[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