Hi,
Im using a stored proc to select data from a table. I want to select up to the last five records that the stored proc creates. However ive tried using the objRS.MoveLast method but get the error:
Rowset does not support fetching backward.

Is this because im using s stored procedure? and if so would this method work using an sql statement instead/ how can i do this using a stored proc?

many thanks

Its probably because you're using the default ForwardOnly cursor. Maybe you should change to use another type such as a static cursor. Alternatively why can't you just amend the stored proc so you only get back the 5 records you want?