Dim cn As New ADODB.Connection cn.CursorLocation = adUseClient cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\db1.mdb;Mode=ReadWrite;Persist Security Info=False;Jet OLEDB:Database Password=123456" Set rstSchema = cn.OpenSchema(adSchemaTables)Do Until rstSchema.EOF If rstSchema!TABLE_TYPE = "TABLE" Then Combo1.AddItem rstSchema!TABLE_NAME End If rstSchema.MoveNext Loop rstSchema.Closecn.Close
cn.CursorLocation = adUseClient
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\db1.mdb;Mode=ReadWrite;Persist Security Info=False;Jet OLEDB:Database Password=123456"
Set rstSchema = cn.OpenSchema(adSchemaTables)Do Until rstSchema.EOF
If rstSchema!TABLE_TYPE = "TABLE" Then
Combo1.AddItem rstSchema!TABLE_NAME
End If
rstSchema.MoveNext
Loop
rstSchema.Closecn.Close
数据库和程序放在同一个目录里
如果要用1楼的方法用ADO解决,首先你要在项目中添加com中的ado引用....