>>Do the four programs USE the same files? And do they have the tables open or do you leave it to the SQL to USE the tables? I had that problem (more common though) until I put all the tables I touched into the DE and made sure that exclusive was .f.. One more thing... are you running Vshare.386?
>
>There is no interface so no form so no DE. This is the WWW server control by FoxPro. It runs on NT so I don't think VShare is applicable. Tables are open on the fly. If first open the table and then I do INSERT INTO.


So what you're saying is that once about every 4000 times the program executes, that different iterations of this program try to modify the same data file at the same time, causing an error?

If so, what you need is a way to implement semaphores in FoxPro.

If this is the problem, I have a very elegant solution.

However, it is rather detailed and I don't want to type out a dissertation style thing unless you need it (which, if you do, I will be more than happy to help you implement it!)

Craig