Symptom
When attempting to update entries outside of the ShoWorks interface (such as in
the Companion mode or directly from Microsoft Access), you receive the
following message:
Summary
The entries table cannot be modified outside of the ShoWorks interface because
there are many fields that must be controlled in order to prevent data
integrity problems. Circumventing the interface would mean circumventing all
processes that ShoWorks controls to ensure accurate data and avoids errors that
would otherwise result in program interruptions.
The ShoWorks interface controls processes to:
-
Prevent invalid data types from being entered (such as preventing nulls for
fields that require real numbers).
-
Calculate the correct premium dollar amounts for a given entry when fields such
as division, class, and placings are updated.
-
Ensure only valid classes for a given division are assigned to an entry under a
particular division.
-
Time stamp each entry when it was last updated and who the update was made by
so an audit trail exists as well as importing/update functions can properly
update the most recent entries.
-
Any other processes to ensure accurate data and smooth program
usability.
If you need assistance with updating your ShoWorks data on a quantity basis,
please contact Gladstone to request a quote on
providing data manipulation service.