Everytime I use Recorset1.Movelast I get this error:

Microsoft OLE DB Provider for ODBC Drivers error '80040e24'

Rowset does not support fetching backward.

I have read a few things on this, but the suggestions they give don't work. I have changed the CursorType to adOpenKeyset. I entering adOpenStatic even adOpenDynamic to no avail.

I have not change any of the other numbers becuase I don't really know what they would need changed to.

What am I doing wrong? Here is what Ultradev generated minus my change to the Cursortype. It was CursorType =0. I also changed this value to 3 and I still got the error.

set User = Server.CreateObject("ADODB.Recordset"
User.ActiveConnection = MM_Ident_STRING
User.Source = "SELECT * FROM usr User.CursorType = adOpenKeyset
User.CursorLocation = 2
User.LockType = 3
User.Open()
User_numRows = 0

User.movelast
User.Fields.Item("us_pra_id ".Value = practiceID
User.Update