Viewing Table Descriptions in ADP`

[Dean]

How can I view the description property of the SQL server tables in my ADP.
I have populated the extended property in Enterprise Mgr, but the values
don't show up in the database container window.

TIA
Dean

 

[Steve Jorgensen]

How can I view the description property of the SQL server tables in my ADP.
I have populated the extended property in Enterprise Mgr, but the values
don't show up in the database container window.

TIA
Dean

In Access, tables actually have 2 description properties, one that shows in
the database container, and one that shows in the table properties popup in
table design view. if I remember correctly, only the latter is functional in
ADPs.

 

[Malcolm Cook]

The extended property 'MS_Description' on table is visible in MS Access if
you open the table in design view and then choose "View > Properties". Or,
click on table in a Database Diagram and see properties there (with easier
switch from table to table).

I wish it was displayed in the database window's list of tables...

 

[Dean]

Thanks Malcolm, that is what I noticed also. I didn't know if there was some
way to change how Access displayed this property. It looks like the
Description column in the Access database container is useless in an ADP. I
sort of hoped the MS would have this type of thing fixed by now.