How can I get to the comments linked to tables and columns?

[RSW]

In other applications, I can use a SQL statement such as this:

SELECT comments
FROM user_col_comments
WHERE table_name='tbl_Records';

to view comments linked to a table and its individual columns.

I can also use a statement such as

COMMENT ON COLUMN "tbl_Records"."Column" IS 'Description';

to attach a comment.

I have had absolutely no luck getting this to work in Access. Is there any way to handle it?

 

[gemma-the-husky]

not easily - i think they are attributes (maybe properties) of the tabledefs collection

field comments actually show up in the status bar, which is actually irritiating, if you want to make notes for your own use

 

[RSW]

Thanks Gemma. I'm a big fan of Access, and I'm really disappointed it apparently can't handle this well.

 

[boblarson]

Thanks Gemma. I'm a big fan of Access, and I'm really disappointed it apparently can't handle this well.

Well, not every program is like every other one. Some have features that would be nice to have in other programs (like Access) but it all depends on the resources out there to the development team and the amount of feedback they get regarding certain items. I can't say I've heard that this is a much desired feature, so you are probably in the minority on that, sad to say.

 

[gemma-the-husky]

i actually do use the field comments to document / remind myself of some things - but i am conscious that these comments are likely to display on forms, although thats rarely too much of an issue - I doubt if most users even notice them