How to get tables names from mdb database using ADO

[Oscar Rivera]

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

[Peter Hendén]

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

[Oscar Rivera]

Thank you very much!

It works great!