Paul Clement
5/30/2006 3:09:00 PM
On Sun, 28 May 2006 21:25:45 -0400, "gyoder" <georgeyoder@comcast.net> wrote:
¤ how do i get a list of tables after issuing odbcconnection.open? i''m able to
¤ open the connection and use odbcconnection.getschema but is there a generic
¤ method that returns table list?
¤
Dim ODBCDatabaseConnection As New Odbc.OdbcConnection
ODBCDatabaseConnection.ConnectionString = "DSN=AccessDB"
ODBCDatabaseConnection.Open()
Dim TableSchema As DataTable
TableSchema = ODBCDatabaseConnection.GetSchema("tables")
DataGridView1.DataSource = TableSchema
ODBCDatabaseConnection.Close()
Paul
~~~~
Microsoft MVP (Visual Basic)