Hi

I am trying to use adox to find properties of columns in an access database. The specific information I am looking for is Validation Rule and Description. I am able to get the name, type and defined size ok but the Validation Rule and Description always = "" even though I know that information exists. The following is a snippet of code:

For Each oColumn In oTable.Columns

cName = oColumn.Name
cDescription = oColumn.Properties.Item("Description").Value
cValidRule = oColumn.Properties.Item("Jet OLEDB:Column Validation Rule").Value

Next oColumn

Does anyone have a suggestion how I need to change the code?

Thanks
Nichole