Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
List all access mdb file querys
Message
From
21/07/2003 10:33:57
 
 
To
All
General information
Forum:
Visual Basic
Category:
Database DAO/RDO/ODBC/ADO
Title:
List all access mdb file querys
Miscellaneous
Thread ID:
00812003
Message ID:
00812003
Views:
40
hi , how can i list all access mdb file querys and view their code from a vb program

for example this code list all tables and querys

Dim tbls As ADOX.Table
cn1.ConnectionString = "Provider=MSDASQL.1;Persist Security Info=False;User ID=admin;Data Source=test"

cn1.Open
Dim cn As New ADOX.Catalog
cn.ActiveConnection = cn1
For Each tbls In cn.Tables
Debug.Print tbls.Name
Next
Reply
Map
View

Click here to load this message in the networking platform