build a report showing attribute and table descriptions

[Guest]

I wish to build a self gererating data dictionary by using the descriptions
of attributes (fields) and tables to populate the report. How do I return
data on tables not visible in the table section? How do I use system files
and access them?
I use sysobjects, sysproperties and syscolumns in SQL Server to achieve the
same.

 

[Duane Hookom]

You can't pull this directly from tables. You can use a utility like Jeff
Conrad's at
http://home.bendbroadband.com/conradsystems/accessjunkie/csdtools.html.