要使用客户端游标Dim rs As New ADODB.Recordset
rs.CursorLocation = adUseClient
rs.Open "select * from table", cn, adOpenStatic, adLockReadOnly, adCmdText
Set rs.ActiveConnection = Nothing
rs.CursorLocation = adUseClient
rs.Open "select * from table", cn, adOpenStatic, adLockReadOnly, adCmdText
Set rs.ActiveConnection = Nothing
Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
cn.Provider = "SQLOLEDB"
cn.Open "Driver={SQL Server};Server=Develop;UID=SA;PWD=;DataBase=mrp"
cn.CursorLocation = adUseClient '如果少了这句将会出错
Set rs = cn.Execute("select * from bom")
Set rs.ActiveConnection = Nothing '这句也不能少
cn.Close
Set cn = Nothing
Do While Not rs.EOF
Debug.Print rs(0).Value
rs.MoveNext
Loop
rs.Close
Set rs = Nothing
End Sub