I am getting the "3251 - Provider is not capable of request...." error when I run this code. I get the error on the first "calc.Update". Can anyone tell me why?

I have a feeling that it has something to do with the "Order By" clause, but it is pertinent to have it in there. Anyone have any suggestions?


calc.Open "Select date, credit, debit, accountbalance " & _
"FROM creditandDebit WHERE Account = '" & Replace(gstrTemp, "'", "''") & "' " & _
"order by date, time asc ;", cnn, adOpenDynamic, adLockOptimistic

If IsNull(calc!credit) Then
strBalance = -(calc!debit)
Else
strBalance = calc!credit
End If

calc.Update
calc!accountbalance = strBalance
calc.Update

etc......