>>I'm trying to set up an ODBC connection in an interdev project. Within a VB asp page, the error occurs when it hits the line
>>
>>rsBooks.MoveLast
>>
>>I've tried to open the record set with all 5 different parameters that are available through intellisense.
>>
>>The lines to setup the record set looks like this.
>>
>>Set rsBooks = Server.CreateObject("ADODB.Recordset")
>>rsBooks.Open strSQL, dbBooks, adOpenDynamic
>>
>>Dan
>
>Have you tried setting the rs.CursorLocation property to adUseClient (int value of 2, I think, but don't quote me on it). This should let you navigate the RS without any problems.
>
>Hugo

Actually that's exactly what we did, although I don't have the ADO header file yet, so we used

rs.CursorLocation = 3 ' Client side cursor

Dan