Hi Tracy


Is it possible that they are getting into a "deadly embrace" where a an update locking tables in one order meets another update locking the same tables in another order. This could cause them to freeze while waiting for the next table in the order to come available. It would typically only happen when the users are in different forms and only when the update occur at the same time. With different loads on the system other sites might not experience the same problems or may have different procedures so the situation may never occur. Killing off one of the programs also typically frees up the others.

>I have posted other messages here regarding problems at this one site. Originally the problem was a receipt form losing focus and the user having to press the windows button twice to switch it back. There is one Windows 2003 server and numerous Windows XP SP2 workstations. The site has the same hardware as numerous other sites. This is one site in hundreds (actually over a thousand) and only this one site experiences problems. We have replaced the server, the switch, all network cables and nics and all printers. For 3 days nothing went wrong then today when very busy, 4 users were in the program and all were on different forms and using different records in different tables. One of them was on the receipt screen. All of a sudden every workstation locked up in our program. The program completely froze for everyone of them. I asked about tape backups possibly running, other apps running, etc but no information from the user on that (according to the users nothing else in
>running). The user on the receipt form killed the app (killed the process) and then the remaining other workstation unfroze on their own. Has anyone seen this in the past? They are using a vfp8 SP1 version of our app. I can verify that exclusive is OFF and multilocks in ON and the file nor the record is locked. Besides, the other workstations were not using the same files or records. Norton Antivirus is disabled for testing. Write cache is turned off on the server and every workstation. Every workstation has at least 512 mb ram.