Records dropping (in Access, I could get 'em back by "reindex") Please help.
I have a database with 5600 odd records. For some reason, and I suspect it's index slippage because it will often be a whole group of records, records disappear. This has happened frequently and I have worked with the file for many more hours to recover the data (export from another database and then import -- then re'enter the data for what should have been logical fields but are numeric fields with a Yes/No mask.
I am just about to start testing with real data. This causes me real concern about using Filemaker unless there is some fool proof way to easily restore these records. I would want my client to have to go through all this b/s. Isn't there a white paper of some sort on this topic? I can't be the only person who has gone through this.