QuickFill uses a database system called Raima Data Manager which has been used in other software products for many years now, so we don't expect you to encounter problems with a corrupted database.
Occasionally, intermittent hardware problems can cause your data to be changed in subtle ways, so we have provided a utility that checks the integrity of the database structure. We strongly recommend that you run a database check daily. You can schedule it to run with the "Tonight's jobs" job list. You can see the date and results of the most recent database check on the 'About QuickFill' screen which can be displayed by clicking the blue "information" icon on the toolbar.
The "Check Database" screen lets you speed up the process of scanning the database by electing not to check for certain types of errors. However, we recommend that you use the default options unless time does not allow you to do so. If you must skip some checks, we recommend that you rotate the checks that are performed so that eventually all aspects of the database integrity are checked.
Check set membership consistency
Checking the set membership chains involves tracking the links from each customer to his or her subscriptions and from the subscriptions to each order. This option is set by default. Uncheck this box if you do not want to validate the set membership chains.
Note: set membership consistency
The set membership consistency should be checked at least once a week. However, we recommend that you include this option as often as possible, as repairs to set linkages are extremely difficult and time-consuming; they require manual editing of the database.
Check required set memberships
This check involves the examination of set memberships that QuickFill assumes will exist (i.e., orders must belong to subscriptions, subscriptions must belong to customers, etc.). This option is set by default. Uncheck this box if you do not wish to validate the required set memberships; this particular option does not have any effect on the amount of time that it will take to run the database check. In addition, missing set linkages cannot be repaired by running a utility program; like the set membership consistency, repairing linkages for the required set memberships involves manually editing the database.
Check key files against data files
This check will verify that the structure of the key files is correct and that every key points to a valid data record. This option is set by default. Uncheck this box if you would like to skip this part of the database check. If you have a very large database, you may choose to exclude this part of the database check from time to time as errors in the key files may be fixed by running the 'Rebuild key files' command on the 'File' menu.
Check data files against key files
This option is not selected by default. Check this box and QuickFill will verify that every data record has a valid entry in the key files; this is the converse of the check done for "Check key files against data files." Errors in the key files may be fixed by running the 'Rebuild key files' command on the 'File' menu.
Only check this file
You may specify a single data file (number 1 through 13) for which you would like the database check to be run. This option is particularly helpful if a previous database check reported errors in only one file. Once your database has been repaired, you want to run a follow-up database check to ensure that the database file no longer has errors.
Warning: DO NOT USE A CORRUPT DATABASE
If you get any error messages when you run the 'Check database' utility, it means your database is corrupt. Contact Technical Support at CWC Software, Inc. immediately. Some types of errors can be corrected by running specialized utilities that CWC can provide, while other errors may require that you restore the database from a prior backup copy.
When you are ready to run the database check, click on "OK." When you run this utility, you have the choice of running it immediately or as part of a scheduled job. By choosing the latter you can check your database every night as part of the overnight run of reports and updates. If you do this, make sure the database check is the first item in the scheduled update run. If an error is detected by the utility, QuickFill will stop the run automatically, thus ensuring that you don't run labels or bills on a corrupt database.
'Check database' produces a report file that you can print using the 'Print…' on the 'Reports' menu. The last line of the report indicates whether or not any errors were found.
Click here for more information about Options for running the database check.
Shortcut:
Toolbar: