How to change the default crusor type of recordset when executing a stored procedure?
Set the parameters in the following order: rs.CursorType =adOpenKeyset rs.CursorLocation=adUseClient rs.open , Opening a recordset in this manner will change the default connection from ForwardOnly to Keyset.