A system I've been working on for two years has gone live and though it's generally working well we are being plaqued with locked-up computers and occasionally corrupted data files.

My system is based on Visual FoxExpress, and (wouldn't you know it) Mike and Toni went on vacation today for two weeks.

In about five occasions over the past two weeks a locked-up workstation has been rebooted (or end-tasked) and the result has been to corrupt one or both of the reservation files. There are about ten main files but it always these two that get corrupted.

At that point I have to get 30 users out of the system and rebuild the two files by appending from the corrupted files to a good (empty) copy of the files.

I have just added a FLUSH at the end of the SAVE method of my main form class but I don't have this version up yet.

The odd thing is that the corruption is happening in the part of the system that has been live for a year (making year 2000 reservations).

For instance, today one of my users had finished using the system and had minimized it. She tried to bring up WORD and her computer locked up. The computer would not respond to control-alt-delete so after calling for help from another tech person, she turned off her computer. When she came back up she was able to restart the reservation program but within 3 minutes, four other workstations were locked up and when I came in a few minutes later the 2 files were corrupted.

I would appreciate hearing any general guidelines to avoid data corruption and lockups.

I'm using VFP 5.0 and Novell Client 32 on a Netware 4.11 system.

I generally have most of the files open in Data Session 1 with the updates being performed in a private datasession started by a form. I usually have 3 or more forms open (all but 1 hidden) at the same time.

TIA

Peter Robinson