Thank you for this; we will now go away and try to replicate the process with Transaction=>1 for file-based locking. So far, we have never seen proper locking under MySQL but we should try the above argument with File.
Best regards and thankyou for your thoughts on this, it has been a stress for us... I will report back with the outcomes,
Kind regards,
Craig.