1 Reply Latest reply on Feb 22, 2012 11:12 AM by philmodjunk

    FM file reverted to earlier date - data lost



      FM file reverted to earlier date - data lost


      I've used FM for years.  I bought a new version in 2010 when I switched to a Mac.  I entered new data and records w/o problem up to last week.  Today I discovered that my entries have disapeared all the way back to Oct 29, 2011.  I tried to find a restore date in Time Machine that would bring the file up to date, but every date I checked, going back, shows the file as last modified on Oct. 29, 2011.  Apple told me that the problem is with the FM software (though I found the same problem with Excel...coincidence?)  What should I do?  Is my software corrupted?  I'm afraid to go back and re-enter 4 months worth of data if it's likely to disappear again.  Help!

        • 1. Re: FM file reverted to earlier date - data lost

          If you hadn't found the same problem with Excel, I would have wondered if you had left your database open on your computer since Oct 29 and had some settings set up so that it wasn't saving to disk, but keeping all the data in RAM. A crash that could then leave you with out any saved changes to the file since the 29th. But if your Excel file also lost all data since the same Oct 29th date, this would seem to indicate something else has happened and I'm not sure what.

          Some folks get convinced their data dissappeared when it turned out they had more than one copy of their file and they accidentally opened a different, older copy and then saw all their most recent data missing, but it seems unlikely that this would happen with two different applications in the same way.

          In general, FileMaker can't on it's own, just revert back to an earlier copy. Every change you make to the file's data or design is automatically saved so this leaves a puzzle as to how your entries disappeared, not only from your current copy, but also all your back ups. An improperly designed cascading delete could delete large numbers of records, but then your backup copies would have the data.