I have managed to run a SQL stored procedure from the following (after setting up ODBC workspace & connection)..

Set rsTemp=conPubs.Openrecordset('nameofmyproc')

it runs ok, but when I then try and run certain methods on this recordset such as:

rsTemp.MoveFirst
rsTemp.MoveLast etc..

I get a run-time error message saying Invalid operation. I have tried opening the recordset with the 'type' parameter also, i.e.

rsTemp=Conpubs.Openrecordset(nameofmyproc',dbOpenDynamic) etc.. and I still get the problem

Any ideas anyone.
Thanks in advance
Keith