>I have a problem on one of my user sites which has been going on for months and I can't get near it!
>
>Intermittently, about once or twice a month, the users try to enter the system first thing in the morning and are met with the error message 'Index does not match database, recreate index (etc)' and we are forced to restore the previous days backup of the file (much quicker than reindexing 200,000 records on a network).
>
I think this type of problem is usually associated with users shutting down machines without properly exiting the application, or the application itself terminating due to a crash.
If you get the problem during the application, it's possible that it's being caused by the network or disk hardware - the index file being corrupted.
Just some top-of-the-head sugestions.