Private Sub Command1_Click()
Dim sql$, rs As New ADODB.Recordset, sCon$
Dim cnn As New ADODB.Connection
sCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" _
& "D:\customer_lib\30所UserExcelDB.mdb" & ";Persist Security Info=False"
cnn.Open sCon
sql = "select * from 电容 "
Set rs = cnn.Execute(sql)
On Error Resume Next
rs.MoveLast: rs.MoveFirst
On Error GoTo 0
Debug.Print rs.RecordCount
End Sub
Dim sql$, rs As New ADODB.Recordset, sCon$
Dim cnn As New ADODB.Connection
sCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" _
& "D:\customer_lib\30所UserExcelDB.mdb" & ";Persist Security Info=False"
cnn.Open sCon
sql = "select * from 电容 "
Set rs = cnn.Execute(sql)
On Error Resume Next
rs.MoveLast: rs.MoveFirst
On Error GoTo 0
Debug.Print rs.RecordCount
End Sub
因为你用了set rs=cnn.execute(sql),这个情况下rs继承cnn游标。所以要设置cnn.CursorLocation = adUseClient