ACC: User with Full Permissions Cannot Change a QueryLast reviewed: May 30, 1997Article ID: Q95328 |
The information in this article applies to:
SYMPTOMSModerate: 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.
CAUSEQueries 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.
RESOLUTIONTo 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.
REFERENCESFor 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
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |