I am accessing a MsAccess database with approx 40000 records and have been
attempting to use the TADODataSet.MoveBy command to move to required
positions within the recordset. I have found that jumping from the first
record to the last record takes a long period of time and have tried to
use
the .Recordset.Move or .Recordset.AbsolutePosition commands as
alternatives
without success. I have been unable to get these commands to move the
record
position and am at a loss to understand why the underlying recordset
commands are not functional.
I would greatly appreciate any help in finding a fast alternative to using
the MoveBy command and assistance in understanding whats happening with
these recordset commands.
Thanks
Mike Henry
