ANSWER:
A:
All record sets created by the Connection Execute method use static and forward-only cursors. If you need to open a different type of cursor, you should use the Recordset Open method.
Answers in Depth...