Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Displaying messy table r'ships

Status
Not open for further replies.

multiplex77

Programmer
Dec 25, 2001
302
SG
Hi,

I have taken over an Access 2000 database with 67 tables and infinitely many relationships (or so it seems like). When I do Tools -> Relationships, I see all the tables, but a very messy array of table relationships that looks like a spiderweb. Is there a way to view the relationships in a more human-readable layout? Can I give a command to SPREAD out all the tables so that they aren't crunched up together?

How about just a list of the tables, their field names and the relationships they have with other tables/fields?

I've tried looking in the Access help but can find anything that facilitates this. Does anyone have any suggestions?

Truly appreciate any help rendered.
 
For a printed report:
Go to Tools > Analyze > Documenter > Tables > Options etc.
 
Thanks sko,

I tried Tools > Analyze and got a message saying I need to install a component from Office 2000. So I put in the Office 2000 Professional CDROM to continue the installation, but I get the message:

"The path 'Microsoft Office 2000 Professional' cannot be found. Verify that you have access to this location and try again, or try to find the installation package 'data1.msi' in a folder from which you can install the product Microsoft Office 2000 Professional."

I checked the CDROM and I *do* have data1.msi sitting in there. When I changed the path to "D:\data1.msi" I still get the same message. Does this happen to anyone else?

Thanks for all the help!
 
Oops...sorry everyone. I made a mistake--I think i put in the SR disk instead of the installer. It *does* work. Please ignore my previous message.

*embarrassed*
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top