When using a command object to execute a stored procedure and assigning it to a recordset, the recordset properties don't work e.g recordcount or movelast etc.

The cursor is client side and dynamic, if I don't use a command object everythings fine but I want to be able to use stored procedures.

Any tips would be much appreciated, cheers.