>I am using MDAC 2.6 and jet. I copied and pasted Eric's code and was able to successfully see the messagebox. I changed the Active Connection string to my data source and it didn't work. The data source I was was opening was linked tables. I then changed the data source to the database without the linked tables and it worked just fine. Yeah! Thank You
>
>Next Question:
>
>Is it not possible to see the column properties from a linked table?
>
I am afraid that it is not possible. I have done some work on that lately to discover that behavior and availability is very different between provider.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com