Detailed summary of table structure

[Yunus KALDIRIM]

Is there any function to list table structure? Some type of report include
all the things that we designed in a table. I think there is a report in
Access 2003.But there isn't in Access Xp. If you know any other utility
software for this please write.

Thanks,

 

[Douglas J. Steele]

There's a built-in database documenter in all versions of Access. I don't
have Access 2002 installed on this machine, but in both Access 97 and Access
2003, you get to it through Tools | Analyze | Documenter.

 

[Jeff Conrad]

In addition to the Documentor that Doug mentioned, here is another option.

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 and its field properties (including linked ones) in an easy-to-read format. I recently
finished Version 2.0 of the add-in.

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. He should be back from his well-deserved vacation very soon. (I'm sure his
wife would say long-overdue vacation!) 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 2000, 2002, and 2003. I will need to know which version you need.

 

[Yunus KALDIRIM]

I saw the documenter that Doug mentioned. And I want to use add in also.I use
Access 2002.You can send it y_kaldirim(at)ftml.net ,
Thanks a lot.

"Jeff Conrad":

 

[Jeff Conrad]

Hi,

File has been sent to the address you provided.
Follow these steps to install the Add-In:

1. Unzip the file JVTableList.MDA to your Office or Access directory to easily find it when we
install the Add-In.

2. Now open any Access database and go up to "Tools" on the main Access menu bar. From there go down
to the option called "Add-Ins". This sub-menu will list any installed Access add-ins on your system,
as well as an option called "Add-In Manager". Click on the option called "Add-In Manager" and a new
screen will appear.

3. The box will display a list of available add-ins on the left side. Depending upon where you
unzipped the add-in file, you may see the John Viescas Table Documentor already listed in this box.
If the file is listed, click on the option to highlight it and then press the "Install" button to
complete the installation. There should now be a little "x" next to the option meaning it has now
been installed. If you do not see the add-in listed in this box simply click the button called "Add
New..." where you can browse for the location of the file. Once you find the file and click on it in
the browse window, you will be taken back to the Add-In Manager screen. Now you should see our
add-in listed in the box with a "x" by it meaning it has been successfully installed. If not,
highlight the option and then press the "Install" button to complete the installation. Hit the
"Close" button on the Add-In Manager when finished. That's it, now we're ready to use the utility!

4. To launch the add-in, simply open any database you wish to document and go up to Tools | Add-Ins
and click on the new option "John Viescas Table Documentor". Depending upon the number of tables in
your database (and whether they are linked or not), the utility should only take a few seconds to
create the report and display it on the screen. Once on screen you can either print the report or
just view the different pages.

Please post back to the newsgroup when you receive the file and if have any problems. The e-mail
was being sent from a "dump" e-mail account and will not be checked if a reply is sent. The only way
I will know if you received the file is through the newsgroup.

Hope you find it useful.