I am running the latest version of FMS Advance and my clients access through IWP. I also have another "slave" set up, which is perpetually accessing the application through an FM8 client, to perform a few non-IWP functions. This setup has been working fine, until lately.

On two occasions now, after the user has performed some simple actions (nothing much more complicated than creating some new records), one of my entire tables has lost all of its data.

I have stepped through all the scripts that are used, to make sure none of them somehow get caught in a Loop, calling Delete Record over and over. I've tried going through logs to see what has happened, but I can't seem to find out why this is happening. Both times, I've reloaded data from a backup, and run a recovery on the file to make sure it wasn't damaged.

Has anyone had similar troubles or know of a better way I can see what has happened?

...Running a recovery on a file and then continuing to use that file is never really a good idea...

The file is most likely corrupted, so if you can, extract the data, and re-import it into a slightly older copy... Unless it is the data itself that is corrupted in which case, you might be better off waiting until someone else comes along to help you, but those are my initial thoughts.

After running the recovery, there seemed to be none of the usual indications of corruption (file size difference, missing data, etc.).

The first time this happened, we did exasctly that: we reverted to an earlier version, imported from a slightly older backup, and the user had to re-enter some data manually.

Things ran fine again for a couple weeks, thenwe lost the same table data again. Any other ways to discover file corruption, or any other thoughts on what's happening?