>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
"My get up and go must've got up and went"
-Steve Tyler, Aerosmith