>Thanks a lot, it was indeed a trigger that called a SP which was the culprit.
>
>Do I need to SQLize all the code in the SP in order for this to work given that the trigger code works fine if you update VFP data using VFP?
No you don't need to but check VFP help for a list of commands/functions supported/unsupported by VFPOLEDB driver. IMHO a good designed DB should never have unsupported code in its SPs. VFPOLEDB supported set is much higher for SP than it's for nonSP code.
Cetin