>>>
>>>It going wrong somewhere in there http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_foxhelp9/html/fbad54cc-cf7f-4add-a0d9-ddbeec5e00cc.asp
>>>
>>>Well, they're only a couple of ideas
>>>(2) can be done after tableupdate() - hope it's record buffering
>>
>>No, we're using table buffering. We want to either commit everything or reject everything.
>>
>>Thanks for the link, I'll take a look.
>
>Can you switch off buffering and use a transaction instead ?

No, I don't think it's advisable. Transaction time should be minimum.