Viewing Table Descriptions in ADP`

  • Thread starter Thread starter Dean
  • Start date Start date
D

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
 
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
Click to expand...

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.
 
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...
 
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.
 
Back
Top