how to get the table list? 1

[lordtektips]

help!
I'm using ADO to open a database(Access).How can I get
the table list from the database. I need the table list to
fit into a treeview control.

 

[HermanvLimbeek]

Hi lordtektips,

if you're using ADOX enumerate the tables like:
Dim cat As ADOX.Catalog
Dim tbl As ADOX.Table

Set cat = New ADOX.Catalog
cat.ActiveConnection = YourConnectionString

For Each tbl In cat.Tables
debug.print tbl.Name
Next

Success, Herman :-Q

 

[lordtektips]

thank you for your help
but what is adox?

 

[oneshadow]

ADOX is an extension to the ADO objects and programming model. Under Project/Reference search for "Microsoft ADO Ext.[version] for DDL and Security"

See MSDN for more info

 

[nivedita]

Hi,
I wnat to list all tables which are realted to other tables
how do i do this using ADOX
Thanks
Nivedita