Hi

I am reading a RS with minimum of about 1000 records. To move through the entire RS takes about 23 seconds for 1003 records or put it another way 0.02 seconds per record. What I have done is to open the RS using the SELECT method only retriving the feilds I am interested in. Then I setup a loop...

Do While not RS.EOF
RS.movenext
Loop

Am I doing something wrong? How can I speed up my process.

Thanks for your time

Geoff