2,463
社区成员
发帖
与我相关
我的任务
分享
Dim conn As Object
Private Sub Form_Load()
' 初始化对象实例
Set conn = CreateObject("ADODB.Connection")
conn.open "Provider=Microsoft.Jet.OLEDB.4.0;UID=;PWD=;Data Source=x:\xx.mdb"
End Sub
Private Sub Form_Unload(Cancel As Integer)
' 卸载对象
conn.Close
Set conn = Nothing
End Sub
Private Sub Command1_Click()
Dim rs As Object
Dim rsRecordCount As Long
Set rs = CreateObject("ADODB.Recordset")
rs.open "Select count(*) as c From 表", conn, 3, 1
rsRecordCount = rs!c
rs.Close
Set rs = Nothing
MsgBox "表中有" & rsRecordCount & " 条记录"
End Sub