>*code snipped*
>
>Are you using views? If so, what is the WHERE clause of the UPDATE statement? Is it being optimized? BTW, 20 mins to update 700,000 records sounds fine to me.

No, I'm using tables, not views. Actually, I was not patient enough to wait the finish of process, so I killed VFP...

Now I'm trying David's suggestion...