>Hello,
>
>I've read warnings about using the PACK command to delete records. I understand the process that VFP goes through when PACK is issued. I also understand how theoretically, a dbf file could corrupt or be lost if the computer suddenly crashed or lost power.
>
>I guess I'm wondering if anyone has actually experienced a file corruption or any other kind of disaster while using PACK. Since a client should back up their data files on a frequent basis, data should be easily restored if a disaster really did occur. I always advise clients to perform backups before any kind of maintenance is performed.
>
>I'm developing a fairly complex application, in which records will be tagged for deletion using the DELETE command. The physical removal of deleted records will be performed by the client on an infrequent basis. It seems to me that corruptions are always a potential, regardless of whether you use PACK or program a custom delete procedure. I'm wondering if there is anything else about PACK that causes it to corrupt files besides power loss, hardware failure, or other problems external to FoxPro.
>
>Does PACK behave inconsistently depending on other factors such as available disk space, available memory, or the size of the file being PACKED? Or, is this all just based on the theoretical possibility that a client's computer may suddenly lose power, generate the dreaded Illegal Error, or experience some other kind of disaster while files are being Packed. I have not read anything indicating any problem with PACK, except for the possibility of a freak accident, such as a coincidental loss of power occuring during a PACK operation.
>
>As you can see, I really want to use PACK, since it will make my life easier. However, if anyone has prior experiences of PACK directly causing corruptions outside of hardware or power failures, please let me know. Otherwise, I rather just warn clients to always backup their data before performing maintenance.
>
>Thanks for any advice or comments,
>
>Dave

You can download a demo of Stonefield Database Toolkit 5.1 from www.stonefield.com
It gives an excellent overview of some of the maintenance issues facing VFP developers.