How to get tables names from mdb database using ADO

Does anyone know how to get the tables names from
a mdb database using ADO (at runtime).

I am using visual c++ 6 sp3

Thank you

Oscar

From memory it goes something like this


// Assuming ADO 1.5 or greater
IADOConnection conn

conn->OpenSchema (adSchemaTables, nullVariant, nullVariant, &pIADORecordset)



I can't remember the exact usage of the second and third arguments, but they are usually set to null variants (or maybe error) for this type of query.

Hope this helps somewhat.

Regards,
Peter

Thank you very much!

It works great!