Scheema of an Access database

QurbanDurrani
QurbanDurrani used Ask the Experts™
on
Hi Experts,
If I have a database with many tables opened in Microsoft Access.
How do I get the schema of the database, meaning how do I find the relationships amoung the different tables.
Thanks for your help.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
Look for "relationships" in the menu hierarchy.  In Access 2007 it's on the Tools menu. Can't remember where it is in prior versions, but it's there somewhere.  

After the relationships view is open, you can add as many tables as you like to graphically see the foreign key relationships.  I suppose if you want the entire schema, then you'd need to show all tables.  

Also, you may need to reposition the tables (by dragging them) to get a readable  presentation.  If you  have a lot of tables, it's probably best to work on subsets (subject areas) of the tables at one time.
Commented:
This depends on the version of Access you are using.
For example in A07 select the Database Tools Tab and select Relationships.
The diagram may or may not appear, or may not be complete.
Select the All Relationships button...

Remember too that relationships can be built within queries and will not appear here.

Which version are you using?

Cheers
JC

Commented:
FYI:
A2010 same as A2007 and A2002/2003 is in the Tools menu.

Cheers
JC

Author

Commented:
I am using 2003 version and have found the Relationships item. Thanks for your help guys.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial