Problems with the OpenSchema method

[Forest Dragon]

Hi everybody!!!

I have a problem with the OpenSchema method. I want to display all the tables and the queries in a database with their fields. The method shows all the tables and the queries but not all the fields!!! There are tables/queries which it shows only part of the fields, and there are tables/queries which it doesn't show any fields at all!!!

Can anybody give me an explanation why it is so and what I need to do in order to fix that?

Thanks!!!

[Clunietp]

I believe that the driver has to support the functions being called by ADO, and drivers have a varying level of compliance. What database/driver are you using?

[Forest Dragon]

I am trying to connect to an Access database through the Microsoft Jet OLEDB 3.51 provider.

[Clunietp]

Get the fields via OpenSchema(adSchemaColumns)