Navigation: DATABASE MAINTENANCE >
Validating Your Database
The Firebird database software used by all versions of ACCOUNTS includes a feature for checking that the database is not damaged. This does not in any way check whether you have entered correct data. It is rather checking for the sort of damage to files that can happen if your turn off your computer while the program is in the middle of updating the database. (Obviously, we would strongly advise against doing that!) Such damage can also occur if your computer suddenly crashes while the program is in the middle of updating the database
To validate your database, just run Database ⇒ Validate Database. When it is done, it will give the message "The database validation did not find any problems" if that was the case, and will display the errors if there are problems found. If any errors are found, please email the displayed errors to technical support for assistance.
Just to make sure users catch this very unusual problem if it occurs, ACCOUNTS actually prompts you and does this automatically once a month, as you are exiting the program. The only issue that can come up is for users of the Local Network Version or OnDemand Version who are allowed to have multiple simultaneous users, because the validation can only be done when there is only one current user of the program logged in.
There is probably no reason to run this option manually unless something very strange is happening. In that case, the program may not even start successfully, in which case you will not be able to run this option from the menu anyway! In that case, contact us for technical support.
Easy Validation Problems Fix
There have only been ever been a handful of cases (out of thousands of users!) that we can recall where a user has informed us of a validation error in their Firebird database, so as you can see, this is a very rare problem. In those cases, it turned out that it was very easy to fix the problem. The user restored their latest backup database, checked the validation again, and it was fine.
If you do have a validation error, you could try the following steps:
•Be clear on where your most recent database backup is. (Call this "Backup A".)
•Make another backup, with Backup/Restore ⇒ Backup Database, being sure not to overwrite that previous backup. I.e. either store it in a different place, or with a different filename. (Call this "Backup B".)
•Restore Backup B, that you just made, with Backup/Restore ⇒ Restore Database.
•Check the validation, with Database ⇒ Validate Database. If it's OK now, you are done.
•If it's still not OK, and Backup A isn't too old (so you are willing to redo all data entry since that backup was made), restore Backup A with Backup/Restore ⇒ Restore Database.
•Check the validation, with Database ⇒ Validate Database. If it's OK now, you will just have to re-do any data entry since that backup was made.
If you did have a validation problem once, you should probably also continue checking the validation periodically, to make sure whatever problem you originally had doesn't recur.
If the above steps didn't work, or Backup A was so old that you really didn't want to go back to it, please contact technical support, and email Backup B to us as an attachment, so we can look at it and see whether we can fix it in some other ways. It is entirely likely that we will not be able to do this, though, so this is another reason to be sure to backup regularly!