Printing Database table configuration

[cns-master]

Hello every body,
I'm new on this forum and need some help.
I've created a database with MS-Access 2002 and I'd like now to print the configuration view of all my tables, the defined table links etc.
So all the configuration stuf of my database but not the data content.
Does someone know a nice tool for such a work (i.e like PrettyCode Print for VB) ?
Thanks for your help

[RobDog888]

You mean that you want to printout the table relationships?
If so go to Tools > Relationships... > and then File Print Relationship...

[pclement]

How about using Tools...Analyze...Documenter in Microsoft Access?

[RobDog888]

How about using Tools...Analyze...Documenter in Microsoft Access?Nice one ;). Could that be duplicated in code for easier access?

[pclement]

Nice one ;). Could that be duplicated in code for easier access?

Probably through DoCmd and/or RunCommand via automation, but I haven't tried it.

If you're looking for a flexible code solution you would probably have to code your own using DAO, Access SQL DDL, ADOX or ADO schema methods.

[RobDog888]

Yes, I was looking for something easier then using ADOX.

Thanks anyways. I will double check those for something.

[cns-master]

Thanks Paul,
that was exactly what I was looking for (an it was 2 click away....)

regards,