>I've read somewhere that with 10,000 records or more, a SCAN can cause problems. And the table has anywhere from 30,000 - 50,000 records. However, this program has been working smoothly for 2 years now. This is the first time this has happened.
Are you sure it's not a bad index somewhere? I would look at that first, re-build all indexes from scratch. Also, is everything open EXCL, is it possible a record is locked somewhere?
Also, have you tried testing it just by using a loop of:
DO WHILE NOT EOF()?
That will clear the SCAN of any blame if the problem still occurs, or else point the blame to it.
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.