Database Access

---

Setting global read/write privileges

---

The administrator controls the "global" ability of users to lock and unlock data entry forms by granting "Write" access to records that have been previously saved. This allows users to make changes to the data entry forms and their underlying records in the database. Forms that cannot be unlocked are considered in "Read Only" mode (see Unlocking formsUnlocking forms). The changes made using this Preferences item are used as a default when the user does not have special access privileges assigned (see Assigning read/write access privileges).

Three options are available from the pop-up list

Full access allows all users to unlock records at any time by default (gives them "Write" access to previously saved records).
Limited time access allows all users by default to unlock a record for a limited number of days after it has first been saved. An entry box allows you to specify the days.
No access restricts users from changing (unlocking) records after they have been saved for the first time.

The administrator is always capable of unlocking all records. The administrator can also use the checkboxes on this form to allow:

Subadministrators to unlock all records.
Subadministrators to delete records.
Subadministrators to set lock/unlock privileges for other users.

Note: Regular users can never delete records with the exception of Reminder records.

Related topics

Setting table record privileges

Unlocking forms