Private Sub Command1_Click() Dim conn As New ADODB.Connection Dim rs As New ADODB.Recordset Dim strTable, strInfo As String conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\Microsoft Visual Studio\VB98\BIBLIO.MDB;Persist Security Info=False" Set rs = conn.OpenSchema(adSchemaTables) For i = 0 To rs.Fields.Count - 1 strTable = strTable & i & rs.Fields(i).Name & vbTab Next MsgBox strTable While Not rs.EOF If Not IsNull(rs.Fields(2)) Then S = S & rs.Fields(2).Value & vbTab End If rs.MoveNext Wend MsgBox S '数据库所有表名 End Sub
Dim db As New ADODB.Connectiondb.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=路径;Persist Security Info=False" 这样就可以了,你看看吧,
Dim conn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim strTable, strInfo As String
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\Microsoft Visual Studio\VB98\BIBLIO.MDB;Persist Security Info=False"
Set rs = conn.OpenSchema(adSchemaTables)
For i = 0 To rs.Fields.Count - 1
strTable = strTable & i & rs.Fields(i).Name & vbTab
Next
MsgBox strTable
While Not rs.EOF
If Not IsNull(rs.Fields(2)) Then
S = S & rs.Fields(2).Value & vbTab
End If
rs.MoveNext
Wend
MsgBox S '数据库所有表名
End Sub
这样就可以了,你看看吧,