So, since I can not the the execute method of the connection object, I thing I'll change the code.
Thanks again Dave
>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.
<><><><><><><><><><><><><><><><><><><><>
<><> REMEMBER,,,,KNOWLEDGE IS POWER <><>
<><><><><><><><><><><><><><><><><><><><>