By the way, a good reliable UPS on network hubs/switches is absolutely required as well. If power fails and your network ceases to transfer data, it doesn't matter whether your server and workstations are still up or not.

>A programmer here at work is having trouble with losing data when there is a power failure. Since some of our stores have lost data that was apparently saved, he does tests that involve turning power off, to simulate a power failure.
>
>The sample program does a FLUSH, and also closes tables and database (which I consider overkill, but just in case...). We already disabled write cache on the hard disks. But still, data gets lost when power is turned off.
>
>Is there anything else we have to watch out for?
>
>Would a later version of VFP help?
>
>TIA,
>
>Hilmar.