The program hangs and I can't even interrupt it to suspend and see which record it is sitting on. I have a wait window just to show me which step the program is currently at, and I can't get that to disappear as well. It's reall weird!!! I can try using a DO While NOT EOF(), but I don't think the SCAN is a problem. As I said, it's been running perfectly for 2 years now. How else can I check for corrupted tables. Sometime I do get an error on a temp file that I use when merging the records. It says 'Not a table' when trying to use this file. I replace it with a good copy of the file and it works fine. But it could be related, do you think?

>> The 'Not a table' error probably is related to your hanging program. I get this occasionally when the network connection gets lost during a program. Mostly with Fox 2.5 programs though, I rarely see this happen in VFP. In VFP I only remember seeing this on systems using Novell, where I update using transactions. I usually can even End Task the program and not get a corrupted table.

As for the checking for corruption: as Bruce said you can try to rebuild all indexes (PACK) all the tables. You might also try to write the data to a textfile, maybe this will detect a corrupted field. I once have seen data corrupted in a way that would give you a GPF the moment you inspected a memo field.

There may also be programs around here in the files section that will check data for you. I don't know.

Regards,

Auke