>>We get a FILE IS IN USE BY ANOTHER" error very frequently lately. All of them in the largest database (750.000 records). There are 50 users and the frequency of the error is about 20 every day. Yesterday the server was very slow and the occurence of the error increased to over a hundred!
>>The errorline is mostly an INSERT INTO
>>Could it be that FoxPro tries to lock the record but does not succeed within a certain number of milliseconds or so?
>>SET REPROCES TO 0 doensn't effect this.
>>Is FoxPro not able to handle tables of this size or is there a solution?
>>
>>Thanks,
>>
>>Marco Beuk
>Marco,
>Insert into would need a lock of header. With slow connection + set reprocess to 0 users might end in an endless wait too. I would suggest "set reprocess to 1" and then in a loop try insert into with error checking. If couldn't inserted, delay for sometime (ie: for x=1 to 10) and then retry.
>Cetin

---

Sorry for interrupt. if change code on use Append from Array help ?!
Or because of too much user access same table at same time!?

The weak wait for chance, The strong bid for chance,
The clever notch up chance, but The merciful give you chance.