本帖最后由 吕?布 于 2012-4-5 08:14 编辑
Option Explicit
' 引用Microsoft DAO 3.6 Object Library
Sub OpenDB()
Dim db As DAO.Database
Dim rst As DAO.Recordset
Set db = OpenDatabase(ThisWorkbook.Path & "\" & "DATA.mdb", False, False, "MS Access;PWD=123")
Set rst = db.OpenRecordset(Name:="取水许可台帐", Type:=dbOpenDynaset)
If rst.RecordCount > 0 Then
rst.MoveLast
MsgBox rst.Fields(0).Value
End If
rst.Close
db.Close
End Sub