Data Verification

How Do I...

Data Verification is a Sage 50 utility that allows you to verify if any of your data files are missing or possibly damaged. During the verification process, Sage 50 makes any needed changes so that your data records are compatible with Sage 50 data formats. For example, if an ID in a data record has more than the maximum allowable characters, Sage 50 will truncate the ID. Also, any files that Sage 50 finds to be corrupt and unusable are deleted during the verification process.

Following verification, Sage 50 generates a log that details all errors encountered and reports on any changes made, as well as any corrupt records deleted.

  • To run this utility, open your company, and select Data Verification from the File menu.

Warning! It is vital that you back up your company data before you verify data with this utility; if the procedure is not successful or your computer locks up during a test, you could lose valuable data.

The following are types of tests you can perform.

Data Reliability: Verifies that all data files within your Sage 50 company are set up correctly and use the proper, required format. If errors are found, you will be instructed on what to do. In most cases, Sage 50 will attempt to correct data errors for you.

Note: If you are working in a network environment, the computer on which the data reliability test is run must be in single-user rather than multi-user mode. (Sage 50 Premium Accounting and higher)

Data Access: Verifies that your data path is valid and that Sage 50 can access all your data files successfully. For example, your data may be stored on a network. This test searches for all linked Sage 50 data files for the current open company.

Both Tests (recommended): Performs both the Data Reliability and Data Access tests. We recommend that you choose this option.

Each time you run the data verification tests, Sage 50 automatically generates a verification error log and places it in your company's data directory; new verification information is added to the log each time the verification tests are run. The log lists all errors encountered during the tests, the start and finish times for the tests, and all changes made during verification, including any corrupt data records deleted.

Note: Once you verify data, Sage 50 strongly recommends that you back up your company data (in its repaired state).