Mark Hayes
mdh at theopg.com
Wed Jul 2 08:14:24 CDT 2003
Hello I am trying to get at the views in an adox.catalog (using XP) Sub bTest() 'uses adox Dim strCon As String Dim cat As ADOX.Catalog Dim vw As ADOX.View Dim Conn As New ADODB.Connection strCon = "Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=E:\Data\db1.mdb" Conn.Provider = "MSDASQL" Conn.Open strCon Set cat = New ADOX.Catalog cat.ActiveConnection = Conn For Each vw In cat.Views debug.Print vw.Name Next End Sub I can get at the tables in the same way but not queries. I read that queries in mdb's are listed as tables, but they still don't show up in the tables collection. Cat.views.count always comes back 0 Is this because mdbs aren't fully supported by adox perhaps? Any ideas much appreciated Mark