Solved

Print relationships in Access 2007

Posted on 2011-09-08
3
276 Views
Last Modified: 2012-08-14
Good morning,

I have been given an Access 2007 database to edit. It had 20 tables, 52 queries, and 18 forms.  I am changing some of the field "size" properties. I am receiving a message that says that I cannot change a field size without deleting the relationship.  Since I am not very familiar with the relationships I would like to print them all beforehand so I can set them back to their original state.

Is there a way to print all of the relationships at one time without going into each query individually and printing the relationship.

Thanks
0
Comment
Question by:msis2002
  • 2
3 Comments
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 36502898
0
 

Author Comment

by:msis2002
ID: 36502931
Thank you capricorn1 for your submission. Unfortunately I do not believe this will help me.  I just what to print the relationships of the queries all at one time.  There are a total of 52 queries in this database and printing them one by one is tedious.

Thanks you
 
0
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 36502966
.. oh well, you can get an image of the query builder and paste them to a word doc, side by side and print..
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

803 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