How do I show the tables in a database?

[Aristarco]

I want to show the tables stored in a database so the user can select one from a list. I used to do this in Access VBA with a dblist filled with the command

 SELECT Name FROM MSysObjects

, but now I need to make it with VB 6.0 and it just doesn't work. I made the connection to the database and used a command to make the SQL sentence. Alas, I can't recover the table names and the list dos not fill. Any Ideas?

To boldly code, where no programmer has compiled before!

 

[zemp]

Take a look at the ADO .OpenSchema method. Good examples in the help files and see thread709-501345.

Thanks and Good Luck!

zemp

 

[Aristarco]

Thank you so much for the help! Now my project is up and running. Never heard of this method before. I think I'm rusty. Thanks again!

To boldly code, where no programmer has compiled before!