>>
>>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 ?