Move to specific row in an ADODB.recordset

Hello!

I would like to move to a specific row in a recordset.
For example I would like to get the value "MyText" from the 100. row.
A very slow approach would be

dim l&
for l = 1 to rs.recordcount
if l = 100 then
...

Is there a faster way to go to that specific row?

Thank you for help.

Olaf Jung

"Olaf Jung" wrote in message

> Hello!
>
> I would like to move to a specific row in a recordset.
> For example I would like to get the value "MyText" from the 100. row.
> A very slow approach would be
>
> dim l&
> for l = 1 to rs.recordcount
> if l = 100 then
> ...
>
> Is there a faster way to go to that specific row?
>
> Thank you for help.
>
> Olaf Jung

ADODB.Recordset.AbsolutePosition

However, not every provider or cursor will support this method, nor is
it guaranteed to point always point to the same record (only what is the
current 100th).

-ralph