How to cycle through Recordset 500 records at a time

[Sheriff]

Hi,
I have about 6600 record is access db and it is beginning to bog down when all of the record are selected. Is there a way to get 500 or more records at a time in grid form until you reach EOF
Thanks in advance
Sheriff

 

[BNPMike]

Why not get the records you need each time? You surely can't be using 6600 or even 500 in one transaction.

If you do want a continuous datasheet then 6600 records is not your problem. Something weird is going on if that doesn't happen in the twinkling of an eye. Tell us more - is this some horrible multi-join?

 

[Sheriff]

Thank you for the reply, this is the query, I don't think it will qualify as multi join. The Client just want to have the complete recordset in the grid. It goes without saying that all variables are dimed. I am trying to make it faster.
thanks again

MySql = "SELECT Pawns.*"
MySql = MySql & " From Pawns"
MySql = MySql & " ORDER BY Pawns.PawnDate"

 

[PHV]

Have you tried to create an index on PawnDate ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Sheriff]

Thank you to BNPMike and PHV for the replies, they have been very helpful.

Thanks again
Sheriff