Hi John...


ADO actually has this problem licked.... ADO Recordsets have both a bookmark and an absolute positon property.

In your case, I would suggest using a local view that uses an order by. Then, you can create an index on the field you are actually ordering by - supporting seeks. Now, the record number and the relative position in the table will be in sync.