'添加Command1Private Sub Command1_Click() On Error Resume Next Set Conn = CreateObject("ADODB.Connection") Conn.open "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=C:\bwscale.mdb" Set rs = Conn.execute("bwcust") MsgBox IIf(Err.Number <> 0, "表不存在", "表存在") End Sub
使用ADODC的话可以枚举这个mdb里面所有的表比对一下也可以'引用 Microsoft ADO Ext 2.5 for ddl and security '部件 Microsoft Ado Data Control 6.0(OLEDB)Private Sub Command1_Click() call OpenConnection End SubSub OpenConnection() Adodc1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & "c:\bwscale.mdb;Persist Security Info=False" Dim cat As New ADOX.Catalog cat.ActiveConnection = Adodc1.ConnectionString For i = 0 To cat.Tables.Count - 1 If Left(cat.Tables(i).Name, 4) <> "MSys" Then Print cat.Tables(i).Name Next i Adodc1.RecordSource = "select * from bwmain" Set DataGrid1.DataSource = Adodc1 End Sub
http://topic.csdn.net/u/20070806/15/723993cb-69dd-4709-9495-cb6656721e82.html
On Error Resume Next
Set Conn = CreateObject("ADODB.Connection")
Conn.open "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=C:\bwscale.mdb"
Set rs = Conn.execute("bwcust")
MsgBox IIf(Err.Number <> 0, "表不存在", "表存在")
End Sub
'部件 Microsoft Ado Data Control 6.0(OLEDB)Private Sub Command1_Click()
call OpenConnection
End SubSub OpenConnection()
Adodc1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & "c:\bwscale.mdb;Persist Security Info=False"
Dim cat As New ADOX.Catalog
cat.ActiveConnection = Adodc1.ConnectionString
For i = 0 To cat.Tables.Count - 1
If Left(cat.Tables(i).Name, 4) <> "MSys" Then Print cat.Tables(i).Name
Next i
Adodc1.RecordSource = "select * from bwmain"
Set DataGrid1.DataSource = Adodc1
End Sub