Viewing relationships

  • Thread starter Thread starter Teo
  • Start date Start date
T

Teo

Hi!
I have a DB that I didn't create.
When I go to look at the relationships, there are like 40 tables, with about
100 relationships (seen with the lines).
Is there another way to print out the relationships between the tables so
that I can use it to improve the DB?
That way I can see which table points where and I'll be able to use it. But
so far with so many relationships on the diagram I can't see anything.

Thanks much in advance,
Teo
 
Hi!
I have a DB that I didn't create.
When I go to look at the relationships, there are like 40 tables, with about
100 relationships (seen with the lines).
Is there another way to print out the relationships between the tables so
that I can use it to improve the DB?
That way I can see which table points where and I'll be able to use it. But
so far with so many relationships on the diagram I can't see anything.

Thanks much in advance,
Teo
Click to expand...

There are some good third-party relationship viewers - Stephen Lebans
(www.lebans.com) has a good one IIRC.

One just-Access trick is to make a COPY of the database; open the
relationships window and clear it completely. Add one core table and
use the View Direct tool to view the tables connected only to that
table; you can then select each (or some) of them in turn and View
Direct again to crawl out the tree. You can delete table icons from
the window without affecting the relationships; only by selecting the
join line itself can you change or delete the relationship.
 
John,

Well I visited Steve's site and the file mentioned below did not jump out and bite
me.

Do you happen to know the file name for the "viewer" ?

Thanks in advance!

Dennis
 
My guess is that John was refering to the WindowToBitmap file in the "Other"
section.

--
George Nicholson

Remove 'Junk' from return address.
 
Access comes with a Print Relationships Manager under Tools->Addins.
If your diagram is too large and prints across multiple pages then you
can use this Utility to export the entire diagram as one large Bitmap.
YOu can then print this Bitmap on one or more pages.
http://www.lebans.com/windowtobitmap.htm

Finally I just posted this tonight:
http://www.lebans.com/saverelationshipview.htm
NEW - Jan 21/2004 A2KSave-RestoreRelationshipWindow.zip is an MDB
containing functions to Save and Restore the Relationships View Window.
Allows an unlimited number of different Relationship Window Views to be
saved.

Here is the Access97 version:A97Save-RestoreRelationshipWindow.zip

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 
Back
Top