You must use a client-side cursor when creating a disconnected recordset.
For more information, see Creating a Disconnected Recordset Object.