ACC2000: How to Set Security for Modifying Data in a Query Dynaset (209639)

SUMMARY

You can affect a user's ability to edit data in a query's dynaset by using either of the following methods:

Give the user the same permissions as the query's owner by setting the query's RunPermissions property to Owner's.

-or-
Give the user direct permission to modify the data in the query's dynaset by setting the user or group permissions to Update Data for the designated query and any underlying tables.

MORE INFORMATION

For a user to be able to edit a query's dynaset, one of the following must be true:

The RunPermissions property must be set to Owner's. To set this property, click Properties on the View menu when the query is open in Design view. (This assumes that the query's owner has the appropriate permissions to modify the data.)
The Update Data check box must be selected for both the query and the underlying tables. To select this check box, point to Security on the Tools menu, and then click User and Group Permissions. You must perform this step for each object for which you want to assign permissions.

The following table shows the possible combinations of these three settings and how each affects the user's ability to edit a query's dynaset:

   Permission       Permission       Query's          Edit
   to update data   to update data   RunPermissions   dynaset?
   in table         in query         set to Owner's
   -----------------------------------------------------------
   Yes              Yes              Yes               Yes
   Yes              Yes              No                Yes
   No               Yes              Yes               Yes
   Yes              No               Yes               Yes
   No               No               Yes               Yes
   Yes              No               No                No
   No               Yes              No                No
   No               No               No                No

REFERENCES

For more information about the RunPermissions property, click Microsoft Access Help on the Help menu, type runpermissions property in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.