GetOleDbSchemaTable

[BJGroot]

With the code down here, I can find all the Table Names of a database in Access, but ........ I like to know also the query-names of that database.

 

Can anybody tell me how to do this ? ?

I can't find it.

I'am from the Netherlands so the code is not all English.

 

Greetings Bas.

     Try
        objConnection.Open()
        dbTableNames = objConnection.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, New Object() {Nothing, Nothing, Nothing, "TABLE"})
     Catch ex As Exception
        MessageBox.Show(ex.Message)
     End Try
     objConnection.Close()
     Dim TabelNaam As String
     Dim nr As Int16 = 0

     For Each drTabelNamen In dbTableNames.Rows
        TabelNaam = drTabelNamen.Item(2).ToString
        MakeTabbleButtons(TabelNaam, nr)
        nr = nr + 1
     Next

.........

.........

Edited May 7, 2006 by PlausiblyDamp