是啊 不过我和朋友已经解决了 '请引用 c:\program\common file\system\ado\Msadox.dll '引用active data object 2.0 ,工程-引用-Private Sub Form_Load() Dim cnn As New Connection Dim cat As New Catalog Dim tbl As Tablecnn.Open "Provider=Microsoft.Jet.OLEDB.3.51;Data Source=linshi.mdb" Set cat.ActiveConnection = cnnFor i = 0 To cat.Tables.Count - 1 Set tbl = cat.Tables(i) Debug.Print tbl.Name & vbTab & tbl.Type Next
End Sub
debug.print的前4个是系统表 以后的才是你自己建立的库表
debug.print ******************************* MSysACEs SYSTEM TABLE MSysObjects SYSTEM TABLE MSysQueries SYSTEM TABLE MSysRelationships SYSTEM TABLE 职工工资 TABLE selectfrom职工工资 VIEW
'请引用 c:\program\common file\system\ado\Msadox.dll
'引用active data object 2.0 ,工程-引用-Private Sub Form_Load()
Dim cnn As New Connection
Dim cat As New Catalog
Dim tbl As Tablecnn.Open "Provider=Microsoft.Jet.OLEDB.3.51;Data Source=linshi.mdb"
Set cat.ActiveConnection = cnnFor i = 0 To cat.Tables.Count - 1
Set tbl = cat.Tables(i)
Debug.Print tbl.Name & vbTab & tbl.Type
Next
End Sub
以后的才是你自己建立的库表
*******************************
MSysACEs SYSTEM TABLE
MSysObjects SYSTEM TABLE
MSysQueries SYSTEM TABLE
MSysRelationships SYSTEM TABLE
职工工资 TABLE
selectfrom职工工资 VIEW