I have a stored procedure in SQL Server that returns a recordset.

In VB, I have an ADO command that executes the stored procedure to retrieve the recordset.

So far, so good.

The problem is that the recordset is Cursor Type 'adOpenForwardOnly'.

I want anything other than a 'forward only' recordset (like static or something) but I can't change it.

Any ideas?