Being nit-picky is OK, isn't it ?? ;-) I usually work with SQL server, so I 
wasn't actively aware of the difference between the Caption and the 
Description properties. Thanks for pointing that out.

Anyway, this is what the MSDN says about it:

<SNIP>
The Properties collections in ADO contain a dynamic set of properties 
returned by the OLE DB Provider being used. The tables to follow contain 
the list of properties, both standard OLE DB and provider-specific, that 
are available in the Properties collections of ADO and ADOX objects when 
using the Microsoft Jet 4.0 OLE DB Provider.
</snip>

This sounds to me that there are provider specific properties and that ADOX 
just passes it through, not??

Funny, though, that Caption is not implemented. I looked at the (complete 
??) list at 
http://msdn.microsoft.com/library/techart/daotoadoupdate_topic14.htm but 
couldn't find anything that has to do with the Caption property.


Imar



At 08:07 AM 1/25/2001 -0800, you wrote:
>At the risk of appearing nit-picky, the caption and description props are
>actually two different things (tho description may be a good substitute for
>this application).  If you were to open the table in the access UI, the
>caption property would be the column heading, and the description would be
>the status bar text.
>
>I've played w/this just a little bit & it looks to me like you can't append
>custom props to column objects using ADOX--the .Properties collection just
>has .Count .Item and .Refresh members--no .Append.  Is this right?  I guess
>that actually makes sense, given ADO's goal of being provider-independant...
>
>Cheers,
>
>-Roy