I'm trying to get a Dynamic cursor in a recordset, but I'm using a command 

object to select a range of records in a database and not opening the whole 

database with the recordset object.  Is there a way to specify the cursor 

type in a command object before you set it as a recordset?  Something like 

this:



commandObject.CommandText="SELECT * ..."

commandobject.???????=adOpenDynamic

SET recordset = commandobject.execute



where the ??????? are the command that would set the cursor type.



Thank you