Printing a large Database Relationship Diagram in MS Access 2007
Posted on 2008-09-29
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.