Hi Ian.

Here is a theory but not necessarily the answer. You are using pessimistic row buffering, right? When you installed the application you had no serious problems maybe because you had no serious amount of data. As the tables grew, the odds of a file locking embrace grew. How are you handling data collisions, where two users may be modifying the same record at the same time?

Is it also possible that you have pessimistic table buffering going, accidently? That would really gum up the works.

Look carefully at your data, Ian. Again, I don't have a direct answer but I "smell" trouble.


>I have had an app running for 2+ weeks without any serious problems, and then late last week, the app started to hang users machines. It appears to happen only when a user presses a button that results in them changing to a different form.
>
>While the machines can lock at almost anytime, they usually lock after a few hours of use. They either hang (i.e. CNTL ALT DEL, does nothing) with the HDrive light on (although I have not been able to hear the HDrives grinding away as I would expect), OR the CAN NOT READ FROM DRIVE C: blue screen appears. Either way the user has to power down their machine.
>
>Typically when a user clicks a button to go to another form, the code looks something like:
>< CLOSE tables all
>< CLOSE databases all
>< Clear windows
>< DO FORM XXXX.SCX
>
>I also have a form in which I used:
>< thisform.release
>instead of the CLEAR WINDOWS line but the same hang prob occurs on that form.
>
>All forms:
>run maximized;
>without any menus;
>with a FIXED DIALOG Boarder Style;
>in the VFP main screen which is sizable with scroll bars;
>
>I thought it might be related to the DB, so I have a VALIDATE DATABASE, PACK DATABASE routine that is now run every night. But this has not helped.
>
>I have also changed all of the UPDATE settings to IGNOR in the Referencial Integrity. Now there is only CASCADE set for some of the DELETE settings in the RI.
>
>All clients have at least 48MB running either Win95 or Win98, pulling the shared data from an NT server (I just upgraded to SP4 from SP3 but had no improvement) with 128MB. The server is almost exclusively for File and Print sharing (i.e. no apps running on the server). All the client HDrives are fast, have at least 300+MB free, and have been scan disked and defragged in the last week or so. The client machines are all Intel P150's or better, running brand name parts.
>
>All my forms use Pessimistic Row Buffering, and I have "editwork c:\
>tmpfiles c:\, sortwork c:\, progwork c:\" in the CONFIG.FPW file.
>
>No other programs are having problems sharing data on the server and no other programs a locking users machines.
>
>My VFP has SP2.
>
>I am out of idea's and getting VERY worried. Any sugguestions would be greatly appreciated.