AnsweredAssumed Answered

Records dropping   (in Access, I could get 'em back by "reindex")  Please help.

Question asked by quirkycrone on Jun 29, 2014
Latest reply on Jul 22, 2014 by philmodjunk

Title

Records dropping   (in Access, I could get 'em back by "reindex")  Please help.

Post

     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.

Outcomes