7,763
社区成员
发帖
与我相关
我的任务
分享
Dim Cn As Object ' 定义连接对象
Private Sub Form_Load()
Set Cn = CreateObject("ADODB.Connection")
Cn.open "Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Database Password=manager;Data Source = " + App.Path + "\data.mdb"
' 定义数据集对像
Dim rs As Object
Dim count As Long
Set rs = CreateObject("ADODB.Recordset")
rs.open "select count(*) as c from 表", Cn, 3, 1
count = rs!c
rs.Close
Set rs = Nothing
MsgBox "查询表的记录数为:" & count
End Sub
Private Sub Form_Unload(Cancel As Integer)
Cn.Close
Set Cn = Nothing
End Sub