Microsoft KB Archive/95328

= ACC: User with Full Permissions Cannot Change a Query =

Article ID: 95328

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 Q95328



Moderate: Requires basic macro, coding, and interoperability skills.



SYMPTOMS
After changing a query definition, you try to save the query but cannot, even though you have full permissions on the query and are a member of the Admins group.



CAUSE
Queries have a property called RunPermissions. You can see its setting in the Query Properties list. If it is set to Owner's, then only the owner of the query can save changes to the query's design. Allowing someone else to make changes would be a security violation.



RESOLUTION
To enable a user with Modify Definition permissions to save changes to a query, the user must first change the RunPermissions property setting to User's.

