table description 1

[Oromia]

How can I retirve a table description programaticaly from access database?

 

[snyperx3]

Dim tdf as DAO.TableDef
Dim fld as DAO.Field

Set tdf = CurrentDB.TableDefs(TableName)
On Error Resume Next
For Each fld In tdf.Fields
'blah blah blah
Next fld

You may need to add a reference to the Microsoft DAO object library.

-Pete

 

[Oromia]

I need to update the column descriptions of tables. I basicaly should read from one table and update the other tables with the descriptions. I have the code which reads from the descriptions. My problem is with updating. Thanks

 

[snyperx3]

fld.Properties.Append fld.CreateProperty("Description", dbText,[red]thedescriptionyouhave[/red])

obviously replacing the part in red.

-Pete