Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. ACC2000: How to Set Security for Modifying Data in a Query Dynaset

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

View products that this article applies to.

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).

↑ Back to the top

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.

↑ Back to the top

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

↑ Back to the top

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.

↑ Back to the top

Keywords: KB209639, kbusage, kbinfo, kbhowto

↑ Back to the top

Article Info
Article ID : 209639
Revision : 3
Created on : 1/26/2005
Published on : 1/26/2005
Exists online : False
Views : 293