Dim MyCon As New ADODB.Connection Dim MyRes As New ADODB.Recordset MyCon.Open Con_Str & Path‘连接字符串 Set MyRes = MyCon.OpenSchema(adSchemaTables, Array(Empty, Empty, Empty, "TABLE")) Do Until MyRes.EOF Cbo.AddItem (MyRes!Table_Name)’在下拉框中显示所有表名 MyRes.MoveNext Loop MyRes.Close MyCon.Close
For i = 1 To db.TableDefs.Count
Debug.Print db.TableDefs(i).Name
next i
Dim MyRes As New ADODB.Recordset
MyCon.Open Con_Str & Path‘连接字符串
Set MyRes = MyCon.OpenSchema(adSchemaTables, Array(Empty, Empty, Empty, "TABLE"))
Do Until MyRes.EOF
Cbo.AddItem (MyRes!Table_Name)’在下拉框中显示所有表名
MyRes.MoveNext
Loop
MyRes.Close
MyCon.Close