Get DB info using ADO

What I'm trying to do (using VB):

Write an application that uses a user input to load an Access DB (.mdb) and populate all of the tables` names in a dropdown so the user can select a table and then it'll populate another dropdown with the fields available for that table.

The problem:

How do I get the names of the tables?

(conn = CreateObject("ADODB.connection")

...

conn.?(1,2...) = table name 1, 2,...

)


Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories