>I have a large vfp5 multi-user system with server data. Virtually all data is buffered in table and views, and even double buffering a few places. There are both automatic and manual Saves/Tableupdates throughout each editable part of the system. A user cannot leave a page or form without an automatic Tableupdate (or Revert).
>
>One of my users reported that he had spent an hour or so editing on different pages and forms, when the machine locked up, and he apparently just rebooted. All his edits were missing from the server data, although there was no other problem with the data. He was quite upset, as we all are when we lose our work.
>
>In this particular process the edited tables are opened EXCL, since part of the process requires it for some heavy-duty full-table processing, though the user did not do any of that in the session.
>
>It may make a difference that the table is opened EXCL, but still, I'm completely baffled by this, and have never seen it before with buffering, server data, and continual updates.
>
>Anyone have any ideas?

I have had very good success with preventing table corruption and data loss by adding FLUSH commands after any Fox command that updates table headers. We have not had any table corruption since.

Rich Dyck