How can I view the structure and links of a database?

[scliffe]

Hi,

I'm looking to view the structure of a database in the same way that Dreamweaver displays the structure of a website, I realise that to do it in every bit of detail may be difficult, but I've only ever managed to view the basics like tables, fields and a list of relationships... Someone once gave me some sample code to show how to build it from scratch to display a tree structure (after I'd completed this current database) but I wondered can it be applied to a pre-written Access database to help me analyze its structure and keep a track of linked and un-linked tables/queries etc.? Or am I not making any sense?!

Thanks

Simon

 

[lespaul]

check out thread181-542880 for a link to an access documenter.

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases:
The Fundamentals of Relational Database Design
Understanding SQL Joi