How to print Table Names and fields

  • Thread starter Thread starter Abay
  • Start date Start date
A

Abay

I'm pretty much a newbie to Access, & can't seem to find out how to do a
print out of Tables and field names in the data base I'm settup up. I would
like to be able to refer to a printout for two reasons .. one to refer to
when I am defining data for import from an outside sorce and also for
documentation purposes.

Any help would be much appreciated.

Maggic
 
You can use the Documenter from the Tools->Analyze menu or print your
relationships diagram.
 
I'm pretty much a newbie to Access, & can't seem to find out how to do a
print out of Tables and field names in the data base I'm settup up. I would
like to be able to refer to a printout for two reasons .. one to refer to
when I am defining data for import from an outside sorce and also for
documentation purposes.

In addition to the Documentor function that Duane mentioned, here is
another alternative.

I created an Access Add-In called the "John Viescas Table Documentor"
that does exactly this. It is even easier to use than the built-in Access
Documentor and creates a slick report that will list each table (including
linked ones) and their field properties in an easy-to-read format. I recently
finished Version 2.0 of the add-in. This version even works on MDE files.

Once installed (takes less than a minute) all you have to do is
Tools | Add-Ins | John Viescas Table Documentor. Poof!
After a few seconds a slick report is displayed on the screen. Easy as pie!

I am awaiting word back from John about the possibility of having him post
it on his web site where anyone can download it. In the meantime, I do not
believe he would have a problem if I sent you a copy. If you do wish to have
a copy please let me know where you would like it sent to (please mung the
e-mail address so you won't get spammed!). There is one version for Access
97 and one for 2000 which works with Access 2000, 2002, and 2003.
I will need to know which version you need.
 
Thanks for your reply .. am going to take a look at the documenter, & will
get back to you ..
 
Back
Top