1 Reply Latest reply on Apr 4, 2011 2:26 PM by philmodjunk

    DB Integrity check



      DB Integrity check


      is there a tool, report to run and check your FMP DB relational integrity?  Latley, some strange reason, when I am in the middle of testing, I lose all of my data, they disappear !! Something happens and not only they disapper but when you want to create a new sales record from the contact, nothing happens, all fields are blank? Is this a key issue perhaps? Likely, I had a backup copy of the files but if this was an end user....WOW.....

        • 1. Re: DB Integrity check

          First line of defence is frequent back ups. Even end user clients should make frequent backups. Even if the software is absolutely rock solid, the users aren't and sometimes you need to pull up a back up to correct user errors.

          Next thing is to run a recover on the file and see if any issues are reported.

          There are 3rd party tools such as FMDiff that you can purchase and use also to check the overall health of your file.

          You may also want to examine the details of the relationships you have set up. If you enable the wrong delete options, you can get records disappearing from your file that you did not expect to have disappear when you deleted a record in a different table. These delete options are very useful, but must be used with care. They can form a mushrooming chain reaction where deleting a record in one table also deletes 100's or even 1000's of other records in any number of other tables.