cursor type: opening access parameter query using ado command
Posted on 2002-04-10
hi, i have a situation here.
i have created parameterized in my access data base, and i have successfully run the query and get the result return to my recordset object by using ado command object.
the matter is, the recordset cursor type is adOpenFowardOnly which prevent me to move around the recordset, and once the recordset is open/set, the cursor type cannot be change anymore.
the question is, how can i retrieve the recordset form query using ado command that have other cursor type and location?