>I have a client use ACCPAC Pro6.5. It use VFP7.0 database. One day they find that 50 records in the "POMAST" table is missing. But for sure these records is there before. I check the table and find one empty record marked deleted after the missing record. And there are some old deleted records on the top. How can it happen? the missing records is really gone, it's not marked deleted. Is bad index can cause this? I delete the index and still cannot see the missing records.
>
>The database is always open by someone, so it's impossible someone open the database exclusive and pack these missing records.
A workstation or server crash, or network or power outage, can cause this.
Setting network redirector and disk cache settings conservatively may help:
Thread#
962081
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up