Solved

Printing a large Database Relationship Diagram in MS Access 2007

Posted on 2008-09-29
9
6,046 Views
Last Modified: 2010-08-05
We have a rather large MS Access 2007 database. We have created the table releationships using the MS Access 2007 database diagram tool. We need to print this Relationship Diagram but when we go to Database Tools  and select 'Print Relationship Report', it gives us the following message  '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'.  Making the releationship diagram 'smaller' by taking out some tables from the diagram would make the print out basically useless. We need to see the 'full picture' of all connections/relationships.  We have tried importing the MS Access 2007 relationship diagram into Visio but this did not give us the direct visual field to field relationships that we need. Is there another product that will load our existing Access relationships diagrm and print it out in the same type of format that MS Access currently does? We really need the visual field to field relationships to  be displayed.
0
Comment
Question by:Savtek_com
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
9 Comments
 
LVL 38

Expert Comment

by:puppydogbuddy
ID: 22597601
Did you follow all of the instructions prescribed  in the link

http://office.microsoft.com/en-us/access/HA012141751033.aspx#3
then see this link:
http://www.allenbrowne.com/AppRelReport.html
0
 
LVL 30

Expert Comment

by:Scott Helmers
ID: 22605170
When you imported the database into Visio, did you use the Database Reverse Engineer Wizard?
   http://office.microsoft.com/en-us/visio/HA101154851033.aspx?pid=CH100648911033

If not, it's worth a try.
0
 

Author Comment

by:Savtek_com
ID: 22613700
I appreciate both of your responses.  As per the comment from puppydogbuddy, I tried to use the code suggested in the link but I am still having the same problem - we simply exceed the number of pages an Access report can handle. The output would have been great if it had worked!!

As per the comment from scott, we actually did the reverse engineer for Visio but thank you for the suggestion.

Can the points be assigned even though neither suggestions technically solved the problem? I do appreciate the proposed solutions!
0
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 
LVL 38

Expert Comment

by:puppydogbuddy
ID: 22613916
You can assign points as you see fit, but I wouldn't give up just  yet because we still may be able to help you if you provide more info.  I don't understand what you mean by your saying you simply exceeded the number of pages that Access can handle.  Are you talking about Allen Browne's code? Does his code bomb out...if so, what is the error and on what line is the error?  How many pages are we talking about? I've printed reports in the hundreds of pages on Access and had no problem.  There could be other factors involved...we need more info.  
0
 

Author Comment

by:Savtek_com
ID: 22633409
When I am in Access and I am looking at the Relationships, I select 'Relationship Report' from the Design menu and I get the message: 'The Relationships window is too large to fit in a Microsoft Access Report. Some of the table and/or relationship lines will not show up in your report. To print all relationships make the layout smaller and run the wizard again'. When I run Allen Browne's code I get the same message.
0
 
LVL 38

Accepted Solution

by:
puppydogbuddy earned 125 total points
ID: 22633983
OK, if you read Allen Browne's insructions they say that, in cases like yours, you are to download Stephan Leban's code at this link  http://www.lebans.com/saverelationshipview.htm  and re-run Allen Browne's report.

See this link for an inexpensive tool that will give you a treeview of all object dependencies in your databases.   http://www.aadconsulting.com/objdep.html

Hope this helps.
0
 
LVL 38

Expert Comment

by:puppydogbuddy
ID: 22650350
Thanks for the points and grade, but EE members would want to know what the final resolution was.......Leban's code or the Object Dependency Browser??
0
 

Author Comment

by:Savtek_com
ID: 22650405
Leban's code.
0
 
LVL 44

Expert Comment

by:GRayL
ID: 23176608
If you open the relationships window and press Alt+Print Screen, then open Word and type Ctl+V, you can paste the whole window into a Word document.  Now you have a lot more control over the rendering process.  You are in too much of a hurry to close things down.
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

632 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question