Oracle table column comments

[revlisj]

Greetings,

I’ve linked to an Oracle table from an Access database (via ODBC). I would like to pull in the Oracle table ‘column comments’ into the Access table definition. I’m using Access 2010. In essence, I would like to populate the Access table column ‘description’ value with the corresponding Oracle table column ‘comment’ value.

Cheers

 

[sneuberg]

http://allenbrowne.com/func-dao.html#SetFieldDescription shows code that sets the field description in a table. I guess that's half of your problem.

 

[WayneRyan]

Rev,

The linked table won't have your comments.

Link to the table User_Col_Comments. It'll have the comments.

Hath,
Wayne

 

[revlisj]

Thanks for your responses. Perhaps I didn't state my case clearly enough. I'm looking to pull in Oracle column comments into Access. I attempted to attach a more illustrative example using a Word document but the forum site doesn't allow me to attach the document. The Word document is 711 bytes. I get a message that my attachment (319.5 KB ???) exceeds the 100 KB limit.

Cheers

 

[WayneRyan]

Rev,

You can link to the Oracle table User_Col_Comments.
Then read this table with a DAO record set.
For some of the columns you can TRY using the link to Allen Browne's software
And updating the Tabledef for the appropriate linked table.

You can't design linked tables, BUT you might be able to edit the TableDef
With the description.

If you delete/re link the table you might have to redo the description(s).

You might experiment by just creating a linked TableDef and single-step
With the debugger and see if it's possible in the first place.

Hth,
Wayne

 

[revlisj]

Again, thanks for the feedback. It's too bad Access doesn't embed this functionality with their table linkages. Anyway, I found the 'view' I need with the column comments (SYS.ALL_TAB_COMMENTS).
Cheers

 

[revlisj]

Oops, I meant to say view SYS.ALL_COL_COMMENTS, not ALL_TAB_COMMENTS. Although, I'll bet view ALL_TAB_COMMENTS might come in handy for other reasons.