ACC: User with Full Permissions Cannot Change a Query

Last reviewed: May 30, 1997
Article ID: Q95328
The information in this article applies to:
  • Microsoft Access versions 1.0, 1.1, 2.0, 7.0, 97

SYMPTOMS

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

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.

REFERENCES

For more information about ownership, search the Help Index for "ownership," or ask the Microsoft Access 97 Office Assistant.

For more information about the Run Permission property, search the Help Index for "runpermission," or ask the Microsoft Office 97 Office Assistant.


Additional query words: permissions
Keywords : kbusage ScrtOthr
Version : 1.0 1.1 2.0 7.0 97
Platform : WINDOWS
Hardware : X86
Issue type : kbprb
Resolution Type : Info_Provided


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: May 30, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.