HI

I am opening LARGE record sets with 1000's of records in them. I have made a progress bar to indecate how far through the RS the app has read. What I did was to work out the percentage using Current (RS num / RS record count) * 100. What I notice is if the RS only has 500 records or less this works out to be fine, however if the real count is 700 + it seems to set the record count to 500, read those records then re-set the record count to 700. This makes the progress bar scroll up 100% then down to 85% then scroll back upto 100%

Does anyone know what's causing this?

It is because I open the RS using DbOpenDynaset?

Any takers?

Thanks for reading this essay of a question.

Geoff