为什么ado 的recordset.recordcount总是返回-1????

[大山里的松]

Public objConnection As New ADODB.Connection
Public objRecordset As New ADODB.Recordset
Public strConnection As String

Private Sub Form_Load()
objConnection.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=resistence;Data Source=192.168.0.1"
objConnection.Open
objRecordset.Open "数据", objConnection, adOpenStatic, adLockPessimistic
MsgBox objRecordset.RecordCount

End Sub