Private Sub Command1_Click()
Dim con As New Connection
Dim rs As New Recordset
Dim s As String
con.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\Microsoft Visual Studio\VB98\BIBLIO.MDB;Persist Security Info=False"
Set rs = con.OpenSchema(adSchemaTables)
While Not rs.EOF
s = s & rs.Fields("TABLE_NAME") & vbTab
rs.MoveNext
Wend
MsgBox s
End Sub
Dim con As New Connection
Dim rs As New Recordset
Dim s As String
con.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\Microsoft Visual Studio\VB98\BIBLIO.MDB;Persist Security Info=False"
Set rs = con.OpenSchema(adSchemaTables)
While Not rs.EOF
s = s & rs.Fields("TABLE_NAME") & vbTab
rs.MoveNext
Wend
MsgBox s
End Sub
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货