Microsoft KB Archive/96012

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

Article ID: 96012

Article Last Modified on 1/18/2007

-

APPLIES TO


 * Microsoft Access 1.0 Standard Edition
 * Microsoft Access 1.1 Standard Edition
 * Microsoft Access 2.0 Standard Edition
 * Microsoft Access 95 Standard Edition
 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q96012





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

You can affect a user's ability to edit data in a query's dynaset by changing the settings for the following two permissions:


 * Run With Owner's Permissions, for a query
 * Modify Data, for a 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 Run Permissions 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.
 * The Modify 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 (or click Permissions on the Tools menu in versions 1.x and 2.0). 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       Run with to Modify Data  to Modify Data   Owner's       Edit in Table        in Query         Permission    Query? --  Yes              No               No            No   Yes              Yes              No            Yes No              No               No            No   No               Yes              No            No   Yes              No               Yes           No   Yes              Yes              Yes           Yes No              No               Yes           No   No               Yes              Yes           Yes

