>>If the back-end is already VFP and is not going to be changed, then moving front-end to VFP makes most sense, IMHO.
>
>Indead, the backend is VFP.
>
>And SQL Server is discussed but since the table where the updates are causing problems have about 300,000 records then VFP should not be the problem. Am I right?

Sure, 300,000 records is nothing for VFP. The bottleneck should be in the way you access the data, as John says.