Hi Everyone,
In DAO there is an tabledef object where you have the ability to find out all the names of all tables inside an MDB file. Can anybody show me a code on how to do that in ADO. Thanks in advance.

Newvbguy

if you don't know how to use VB with Access/Sql, I suggest you read the sticky thread: http://www.daniweb.com/techtalkforums/thread41057.html to get a stronger understanding of ADO. Once you are comfortable with that information, you would need to use the OpenSchema method to get the adSchemaTables.... I guess it would be something like:

rsTables = cnn.OpenSchema(adSchemaTables)
do while not rsTables.EOF
loop

or something nuts.

Hi Comatose,
Thanks a lot.. you're really giving us a big help.
have a good day.

Newvbguy

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.