Viewing attribute descriptions in MS Access 2003

[senzafine3]

Hi all,

I am wondering if there is a way to see all tables, their attributes
and the attributes' description all in a single page or something. As
far as I know, the only way to see an attribute's description is to
view the table in design mode.

Being able to see a list of all the tables along with their attributes
and their description (and type) would be very useful in describing the
model to others and also in figuring out if the model would work
properly.

If there is no way to do this in MS Access, is there an alternative way
to do it with ASP? If yes, what would that be and how can it be done?

Thank you

 

[tina]

from the database window, on the menu bar, click Tools | Analyze |
Documenter. in the dialog, click on the Tables tab, select the table(s) you
want, then click the Options... button. select the options you want to see
then click OK, and click OK in the dialog. Access builds the report and
opens it automatically.

hth

 

[senzafine3]

Tina, thank you very much. That does what I had in mind but it misses
the description of the attributes. Is there a way to include that as
well?


Thank you

 

[aaron.kempf]

yeah do you know how to write a query?


se habla sql?


query against msysobjects in access and sysobjects in sql.. in addition
sql server has syscolumns and a friggin hundred other system tables

-Aaron

 

[senzafine3]

Thank you for your reply.

Could you please tell me how would the query be structured in order to
get all tables, their attributes and their attributes description?

Thank you

 

[tina]

i must not be understanding what you mean by "description of the
attributes". please give me a specific example.

hth

 

[senzafine3]

When you see a table in design view, the third column is Description
(the other two are Field name and Data Type)

That is what I mean by the description of an attribute

Thank you

 

[aaron.kempf]

sorry dog i thiink that piece of crap MDB keeps those as properties
that you've got to enum

if you were simply using SQL Server and / or Access Data Projects then
your life would be so much easier!

-aaron

 

[Van T. Dinh]

In the Documenter Dialog, click the "Options ..." button and select "Names,
Data Types, Sizes, and Properties" in the "Include for Fields" pane and the
"Description" Property will be included in the Documenter's report.

 

[senzafine3]

Thank you very much

In the Documenter Dialog, click the "Options ..." button and select "Names,
Data Types, Sizes, and Properties" in the "Include for Fields" pane and the
"Description" Property will be included in the Documenter's report.