Dim con As New ADODB.Connection Dim rs As New ADODB.Recordset con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; " _ & "Data Source=" & App.Path & "\test.mdb;" _ & "Persist Security Info=False;" con.Open Set rs = con.OpenSchema(adSchemaTables) While Not rs.EOF If UCase(rs!table_type) = "TABLE" Then Debug.Print rs!TABLE_NAME End If rs.MoveNext Wend
Dim con As New ADODB.Connection
Dim rs As New ADODB.Recordset
con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; " _
& "Data Source=" & App.Path & "\test.mdb;" _
& "Persist Security Info=False;"
con.Open
Set rs = con.OpenSchema(adSchemaTables)
While Not rs.EOF
If UCase(rs!table_type) = "TABLE" Then
Debug.Print rs!TABLE_NAME
End If
rs.MoveNext
Wend