How to Add "Description" to MS Access (Database - Table) Fields

Jul 18 2012 3:19 AM

Hi,

I am trying to add a column to a MS Access table using following method

   ADOX.Column col = new ADOX.Column();
   col.Name = "OrderDate";
   col.Type = ADOX.DataTypeEnum.adDate;

which is working fine. Now I would like to add column description by my code.I tried some thing like

 col.Properties("Description") = "This is an Example"; 

well as you can see doesn't looks correct! and didn't work. Can you please let me know how I can add field description to my columns?

Thanks for your time and comments