What version of MDAC do you have?

I am on 2.6, and this works fine. I am using a server-side cursor (connection object) and the Microsoft.Jet.OLEDB.4.0

>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