Open your recordset as a static, client side recordset and everything will be ok! Check the properties of the recordset. You *cannot* use the execute method of the connection object.
set ors=server.createobject("adodb.recordset")
>ors.cursorlocation = adUseClient
>ors.CursorType = adOpenStatic
>ors.LockType = adLockOptimistic
ors.open ...
-Dave