I've got a ADO connection to a SQL server database, where a stored procedure is returning the data correctly (I know its worked as I can pull the data back from the first record). However the recordcount is -1 and if I try to move through the recordset e.g

rs.movelast
rs.movefirst

it crashes.

How do you pull back the whole recordset?

Thanks