I think I've found the problem. I think that they've been getting a datatype mismatch error in the trigger code. I also think that they're trying to do too much in the trigger and it's slowing down performance.
>>We have an update and delete trigger which logs the changes to another DBF on a network with about 200 users. We're getting a lot of "Trigger failed" error messages. I suspect because we've got too many people writing to the log table at the same time.
>>
>>Anyone else got any thoughts on this? Am I just blowing smoke?
>>
>>TIA,
>
>How is the log table setup? Does it have buffering enabled? Are you using TABLEUPDATE() to check whether your records were added? If it fails, do you try more than once to update the information?
>
>200 users is well within the "limits" of a VFP multi-user application. You just have to account for the inherent multi-user record contention issues. Maybe they haven't all been addressed.
-cjh