'工程->引用 Microsoft DAO3.x Object Library
Option Explicit
Public mDbs As Database
Public mWrk As Workspace
Dim mRst As Recordset
Private Sub Form_Load()
Set mWrk = CreateWorkspace("", "admin", "", dbUseJet)
Set mDbs = mWrk.OpenDatabase(App.Path & "\db1.mdb")
Set mRst = mDbs.OpenRecordset("Select * From Table1", dbOpenDynaset, dbDenyWrite)
If mRst.RecordCount > 0 Then
mRst.MoveLast '也是RecordCount属性
Debug.Print "记录总数是:" & mRst.RecordCount
mRst.MoveFirst
Do While Not mRst.EOF
Debug.Print mRst.Fields("ID") 'ID字段是你Access表中自动编号字段
mRst.MoveNext
Loop
Else
Debug.Print "记录总数是:0"
End If
mRst.Close
Set mRst = Nothing
End Sub