Microsoft KB Archive/209639

= ACC2000: How to Set Security for Modifying Data in a Query Dynaset =

Article ID: 209639

Article Last Modified on 1/26/2005

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q209639



Advanced: Requires expert coding, interoperability, and multiuser skills.

This article applies only to a Microsoft Access database (.mdb).



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

