Specifications

Using Databases with ID Works Projects 89
ID Works Basic Version 5 Administrator’s Guide
To prevent duplicate values, the column connected to the auto
sequence field should be restricted to unique values using an index or
constraint.
Controlling Database Activities
There are two levels of database access control in an ID Works
project. The database administrator is the only person who can grant
privileges, and granting privileges happens outside of the ID Works
program.
The best place to restrict Production operators’ database access is
on the Database tab of the Edit Production Form Properties dialog
box. There you can prevent operators from creating new database
records, saving changes to records, deleting records, or searching
the database. Note that when you use the Database tab of the Edit
Production Form Properties dialog box to restrict database access,
those restrictions are applied to all ID Works users of the project,
regardless of the user privileges individual user accounts were
granted when the accounts were set up. The print count field
overrides settings on the Database tab of the Edit Production Form
Properties dialog. That is, if Save is cleared on the Database tab of
the Edit Production Form Properties dialog and a Production operator
prints a card, the database record will still be updated to increment
the database table column associated with the print count field.
You can restrict individual users’ database access through the
Manage User Accounts utility in the ID Works Administrator
application. Each user’s privilege to search, add or change records,
and delete records can be enabled or disabled. See “User Privileges”
on page 121.
Any privilege restrictions set outside of the ID Works application
(such as database security) cannot be bypassed.