In a application I currently created when a computer locks up the indexes get trashed. It says Index does not match database or table. Weird thing is it corrupts the index just sitting there, no data to be written to the table, just having the table open..

Is there a fix for this. I could see the index getting messed up if you were writing data to the table, but just be sitting there with the file open?

David