Hi Jolene,

I do similar updates (daily) to a table with over 3,000,000 records, merging somtimes about 200,000 records and I never experience any problems. The program is run (scheduled) on a server and never causes any problems. When I run the program on my own computer for testing purposes, the process sometimes seems to hang and interrupting or canceling the program may take a long time. I suspect this is due to the amount of data stored in memory that has to be written to disk. The program seems to be hanging then, and it takes some patience to wait till it's finished.
Another thing might be that you have corrupted data in your table. In this case you should be able to notice that the program always finshes on the same record though.
If you suspect the problem really to be with the SCAN command (which I doubt) you can always try and replace this with a DO WHILE loop.

Auke