Re: Reporting on tables and fields

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Armen Stein (Armen_RemoveThis__at_RemoveThis_JStreetTech.com)
Date: 03/26/04 

Date: Fri, 26 Mar 2004 00:12:28 -0800

In article <#gUvzxLEEHA.3472@TK2MSFTNGP09.phx.gbl>,
nyannacoREMOVETHISBIT@in.gr says...
> Keith,
>
> From the databae window go to menu item Tools > Analyze > Documenter.
>
> HTH,
> Nikos
>
> "Keitht" <kemery@gladstonemrm.com> wrote in message
> news:11ba801c410bb$b9897a60$a501280a@phx.gbl...
> > I need to produce a report listing all tables and fields
> > within a database project. Is there an easy way to do
> > this, or do i have top use the Tabledefs property and
> > creat my own list?
>
>
>

I find that the built-in documentor shows WAY too much information.

Check out the free "Data Dictionary Report Utility" at
http://www.JStreetTech.com/Downloads.asp

It shows a concise listing of tables, fields and descriptions. And yes,
it uses the collection of tabledefs in code.

Hope this helps, 

-- 
Armen Stein
Access 2003 VBA Programmer's Reference
http://www.amazon.com/exec/obidos/ASIN/0764559036/jstreettech-20
J Street Technology, Inc.
Armen _@_ JStreetTech _._ com