Here are some possibilities for you.
Please read everything.
1. You can use the built-in Access Documentor
(Tools | Analyze | Documentor) to get a huge list of just about everything
you ever wanted to know about the database. At the same time, you can
keep the logging and paper manufacturing industry going strong in Oregon!
Depending upon the options you select, you could fell several trees.
Personally, I would suggest you try my "Doug Steele Object Documentor"
Add-In for Access. This add-in will create a nice report of all your database
objects for easy reference. The report will list all the objects by category in
alphabetical order in a three-column layout. It looks very sweet in my opinion
and it's even easier to use than the Access Documentor. Plus, you get a nice
report saved in your database that you can open again any time you wish!
There is one version for Access 97 and another version that works for
2000, 2002, and 2003.
After installing, which takes all of about a minute to do, you simply do:
Tools | Add-Ins | Doug Steele Object Documentor
That's it! Poof! A nice slick report created in your database in just a
couple of seconds. And best of all, you can use it on any MDB file.
You can find the free Add-In on MVP Doug Steele's site here:
http://www.accessmvp.com/djsteele/Documentor.html
2. I also created an Access Add-In called the "John Viescas Table Documentor"
that documents the table structures. 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.
3. David Hare-Scott has also written a simple table documenter. You can
download it here:
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hare-Scott,David
4. Armen Stein has something here as well:
http://www.jstreettech.com/Downloads.asp
(Look for Data Dictionary Report Utility)
Hope that helps.
