1 Reply Latest reply on Jan 31, 2014 9:20 AM by philmodjunk

    Unexplained deletion of records

    cmartin

      Summary

      Unexplained deletion of records

      Product

      FileMaker Pro

      Version

      13

      Operating system version

      OS X V10.9

      Description of the issue

      I have a file with four tables.

      I was making an adjustment to a portal on one of the layouts and value list. When I exited the layout all the records to that layout table and portal had disappeared.

      I then checked the other tables and 25 records out of a total of 30 had disappeared on one and another remained complete. There is no apparent pattern associated with the five records that remain. Deleting records on the layout and portal which I was adjusting should have no affect on the records of this table.

      There is no logic to the occurrence of the deletion and file recovery has informed me not to continue to use the file.

      Screen_Shot_2014-01-30_at_16.21.55.png

        • 1. Re: Unexplained deletion of records
          philmodjunk

               This suggests that damage to your file is the cause of the lost records. Hope you have a back up.

               Things to keep in mind about Recover:

               While Recover almost always detects and fully corrects any problems with your file...

                 
          1.           The recovered copy may behave differently even if recover reports "no problems found".
          2.      
          3.           Recover does not detect all problems
          4.      
          5.           Recover doesn't always fix all problems correctly
          6.      
          7.           Best Practice is to never put a recovered copy back into regular use or development. Instead, replace the damaged file with an undamaged back up copy if this is at all possible. You may have to save a clone of the back up copy and import all data from your recovered copy to get a working copy with the most up to date information possible.

                

               And here's a knowledgebase article that you may find useful: What to do when your file is corrupt (KB5421).