Thanks a lot Doug, that did it, I kept on setting up a recordset and executing the command into it, but it just gets overwritten by a fresh recordset right?, no wonder, thanks again.

>Hi Jorge.
>
>>It can be done right?, I'm getting server side recordsets regrdless of how I set up the recordset
>
>Set the CursorLocation property of the Connection object to 3 (adUseClient) before calling Open. For example:

>oConnection.CursorLocation = adUseClient
>oConnection.Open("SVEIN","sa","")

Doug