Very good point, Vin. Ben, this may be a good option for you.
>But, Benoit, I have worked with ADO in VB updating VFP tables of about that size and I have not seen such a dramatic slowdown as you report on updating... so in addition to everything that John has mentioned, I think something else, in the code, may also be going on...
>
>Finding that issue, if I am right and one exists, may buy back enough speed to make it worthwhile to hold on until the VFP OLEDB provider becomes available... or maybe not...
------------------------------------------------
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