I have an Access database (97 or 2000) and for various reasons I want to store extended information about the fields in the database. I could probably do this using another table, but I thought I'd use the field description (since this was otherwise unused) However, from VB using ADO I don't seem to be able to retrieve the description property.
Can someone point me in the right direction?
Cheers
Rob
Sat, 21 Aug 2004 23:41:25 GMT
AdoAnywhere Tea #2 / 3
Field Description property via ADO
You can read Description by using OpenSchema calls for column information.
You can write to the field using ADOX as long as you use JET.
My browser supports both.
-- Mike AdoAnywhere: $10.00 Tools http://www.adoanywhere.com
Sun, 22 Aug 2004 00:12:41 GMT
Rob King #3 / 3
Field Description property via ADO
Mike
Thanks for putting me onto OpenSchema. A quick search in MSDN for that and I'm away.
Cheers
Rob
Quote:
> You can read Description by using OpenSchema calls for column information.
> You can write to the field using ADOX as long as you use JET.
> My browser supports both.
> -- > Mike > AdoAnywhere: $10.00 Tools > http://www.adoanywhere.com
Field Description property via ADO