To access the Edit Database Tables screen, pull-down the File menu, click on Utilities, and click on Edit Database Tables.
This utility can be used to view, modify or delete specific records from select database tables. This screen should be used with great caution, and only with our guidance! The removal of records is permanent, and the removal of a record in one table may affect other tables. When deleting a record, there is no second prompt. This could result in illegible data as well as the software not being able to operate properly.
To use this screen, select a table to view. Set your sort criteria and filters if desired, then click Display. The results will show in the grid below. If too many records are returned you can either modify the Filter or limit the number of records returned using the Maximum Records field. You can also change the sort order by clicking the Descending check box if desired.
To modify, add, or delete any record, a password from dESCO is required. This password changes on a daily basis. Should you need to use this utility, contact our support department and they will provide you with guidance and the password should it be necessary. Enter the password into the Edit Password field, and editing will be enabled.