read mdb file backwards.

[crazyswede]

i'm trying to read mdb file backwards. please help me------------------------------------------------------------------------ while(! (rs.EOF)) //READ forward <-- this part works fine{ //567Response.Write( rs("id").Value +"<br>" ) if(rs("id").Value==2515 ) break;rs.MoveNext( ) } //567 .Response.Write( "FOUND EOF<br>" ) .while(! (rs.BOF )) //READ BACKWARDS{ //567Response.Write( rs("id").Value +"<br>" ) rs.MovePrevious( ) <-------------------- this part returns -ADODB.Recordseterror '800a0c93' Operation is not allowed in this context. } //567

[justsomeguy]

You need to open the recordset with a cursor type that allows forward and backward movement. http://www.w3schools.com/ado/met_rs_open.asp