I'm opening a recordset using this code. When I try to MoveLast and MoveFirst
I get an error that says:"This rowset doesn't support fetching backward."

Set adoRS = New ADODB.Recordset 'Create ADO Recordset Object.
adoRS.CursorType = adOpenDynamic
adoRS.Open strSQL, conODBC, , adLockOptimistic,adCmdText


I can open the recordset using DAO and it works just fine
What on Earth am I missing?

Thank you.