Support password for repairing a database

Sage 100 Contractor does not support data entry that would cause your system to be out of balance. In most cases, you can correct entries entered by mistake by posting adjusting entries, journal transactions, or voiding and re-entering transactions.

While you can correct some audit errors, for example, by running the repair option in the 1-6 Period/Fiscal Year Management window, most database errors require help from Technical Support.

We recommend that you always run the repair option in the 1-6 Period/Fiscal Year Management window before calling Technical Support. The repair option rebuilds the balances from the ledger transactions.

Additionally, if a hardware or software failure occurs, you may find it necessary to repair the database because of incorrect or missing data. The following are possible causes for missing data:

• Power failure during the reading or writing of data.
• Turning off the computer’s power supply before exiting Sage 100 Contractor.
• Hard disk failure.
• Other programs causing Microsoft Windows® to fail while a database is open.
• Using a disk cache utility. Disk caching does not immediately write data to the hard disk.

To ensure data integrity, you can only initiate repairs with the assistance of Technical Support. If you have a current support contract, Technical Support can help you to repair the database in most cases. There are circumstances, however, when repair to the database is not possible. If this occurs, you must restore the most recent backup.

To get help with database repair or audit errors: