In addition to the Documentor and code solution that Allen 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 (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.