Hi Benoit,
Record count is only (a small) part of your problem, it's the data access bottleneck that's hurting you. You have to either change the access mechanism through accessing the VFP data from a VFP app using native DML -or- you have to move the data to SQL Server to take advantage of the faster access provided by a native OLE DB provider.
>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?
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05