Table Description

[John Clayton]

If you right click an Access Table name you get the
Properties dialog. In this dialog is a box called
Description: which allows the user to input a description.

How do I input a description into this box using Visual
Basic 6 and DAO?

I have been trying to create a property and append it to
the table, which seems to work when I enumerate the
property.name.

But this does not give me the description, this is
obviously not what I want to achieve.

Can anybody help?

 

[Michel Walsh]

Hi,


? CurrentDb.TableDefs("Table1").Properties("Description")


but it fail with an error if you did not created that property first (through the UI or through the
CreateProperty, then Add it to the Properties collection of the said DAO TableDef object.


Hoping it may help,
Vanderghast, Access MVP