Mapping a Database - System Architecture

[beefster]

Hi - I have a database which has a lot of tables and queries (about 100 of each) that are linked all over the place by macros, other queries, etc....

Unfortunately I stopped writing documentation a while ago - even though the original plan was to keep it upto date as i went along!!

Is there anyway of automatically generating a graphical system architecture to show how all the queries, etc are linked to each other and what tables they produce, etc??

Any help is appreciated greatly!

Many Thanks

Beefster

 

[CCLINT]

Not knowing what database you are using you could use ADOX or the OpenSchema method of a connection.
Most things can be mapped using this.
example: see my post in thread709-501345 and thread709-614350 and the mentioned URLs

 

[beefster]

Its an MS Access DB.

 

[CCLINT]

Then you could ALSO simply use DAO (can be used with ADO in the same project)

Please let me know if this has helped...

 

[beefster]

Yep, thanks for that - I need to read up on DAO and this openschema a bit I think.

Thanks for your help.

Beefster