For..Next problem

[Guest]

Hello.
I have a For.. Next routine to loop through a table. This table has 800 000
records, but the routine breaks around record number 580 000 without any
reason.
The message i receive is "Current record not available".
Why does this happen?

Thanks

 

[Guest]

Post the code so we can see what it is doing.