In addition to the suggestion about records lost in transactions, you can run into problems where the temp attribute is set for table files, and records are lost in the case of an unexpected power failure. See
http://support.microsoft.com/?id=817805 for details.
In VFP6, the PACK or ALTER TABLE command (among others) would cause the resulting table files to have their temp attributes set. This was addressed in VFP7. You can use the code in the article to detect any files with the temp attribute set, and fix them.
>We have a parent/child database system.
>
>Parent is Companies
>Child is People
>The link is the ID which is manually entered for the company then automatically generated for the people.
>
>Is there any known way for people to be missing from the people table, if the data was saved?
>
>I have looked at the table seperately...the names are gone.
>I have looked at the deleted records.
>The table was NOT packed.
>
>We did reindex with INDEX ON all the indexes.
>We did not kill and recreate the tags.
>We did look for the data without any indexes however.
>
>Is this possible?
>Would putting the data into MS SQL make it more secure from the above?
>
>Glenn
Jim Saunders
Microsoft
This posting is provided “AS IS”, with no warranties, and confers no rights.