ADO/ADOX Gurus out there:
I cannot seem to find any way to read the description of an existing field in an existing Access DB. The frustrating part is that I can certainly write one when creating a new field and appending it to a table, but I can never seem to read the description for an existing field.
The following code will work and display the description on the webpage, but only because it reads it from the object it just appended. If I were to close everything, set it to nothing, then open a new object, it cannot be read. One would think that if you can write it, you can read it...am I wrong here?!?
I have tried any number of combinations of objects, properties, and collections from ADO and ADOX. Has anyone actually been able to do this?
Your help is deeply appreciated,
Set objConnDatabase = Server.CreateObject("ADODB.Connection")
objConnDatabase.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strConnDatabase
Set objCat = CreateObject("ADOX.Catalog")
Set objCat.ActiveConnection = objConnDatabase
Set objTable = CreateObject("ADOX.Table")
.Name = "newtable"
.ParentCatalog = objCat
.Item("Field_A").Properties("Description") = "This is a field of numbers"
response.write "<b>The ""<i>Field_A</i>"" field has been added!<br/>"
response.write "description=" & .Item("Field_A").Properties("Description") & "<br/>"