Printing Database table configuration

**cns-master** · 03-01-2005 03:35 PM

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** · 03-07-2005 09:18 PM

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

**pclement** · 03-08-2005 08:42 AM

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

**RobDog888** · 03-09-2005 01:13 AM

Originally Posted by pclement

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

Nice one

. Could that be duplicated in code for easier access?

**pclement** · 03-09-2005 12:53 PM

Originally Posted by VBOfficeGuru

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** · 03-09-2005 06:09 PM

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

Thanks anyways. I will double check those for something.

**cns-master** · 03-10-2005 04:36 PM

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

regards,

Thread: Printing Database table configuration

Thread Tools

Display

Printing Database table configuration

Bookmarks

Bookmarks

Posting Permissions