See the OpenSchema method of the ADO Connection object.
>Hi
>
>Can I access the tables collection, and each fields collection, of a db through ADO? Also "read" their properties, e.g. name, field type/size, etc?
>
>Thanks!
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com
