>Hello all,
>
>I am having some difficulties with a couple of apps compiled to EXEs and ran via the VFP6 SP5 runtime. I have one app that resides on a server PC, its purpose is to import account balance data from text files into a dbf every 15 minutes and usually completes in a couple of minutes. The other app is a client EXE that allows users to view the balance info (query only).
>
>The server side app FLOCK()s the balance table during the import process and the client opens the balance table shared and does a couple of SQL-SELECTS.
>
>The server is a Win2000 Pro PC (P4 1.4ghz, 256M RAM), the client is running Win XP SP1(Dell Optiplex GX240 P4 2.4ghz).
>
>The problem is that the server PC occasionally 'hangs' during a REPLACE in the import routine while the client app is being used. The server does not freeze entirely, the cursor can be moved. But the VFP app freezes solid and will not restart even after the client app exits. No processes can be terminated via the task manager - only way to recover is a hard boot.
>
>The server is also running AS400 Client Access and Launchpad (scheduler)
>
>I cannot replicate the problem on similar hardware. We have looked into the oplocks scenarios with no success. I can't test with the AS400 Client Access since I don't have an AS400 available.
>
>I realize there are tons of variables to consider. Just wondering if anyone else has had this sort of problem.
>
>Thanks
>-Dana
>
>Dana Daugherty
>CNS, Inc.
>Morristown, TN

Dana,

I have not encountered the problem you are talking about.

However, have you considered not to do FLock() at all and updating the table within a transaction.

If only part of the table changes, I can provide you with a piece of code that just updates/inserts/deletes the delta on the whole table or on only part of it