The information in this article applies to:
SYMPTOMS
Moderate: Requires basic macro, coding, and interoperability skills.
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. REFERENCES
For more information about ownership, search the Help Index for
"ownership," or ask the Microsoft Access 97 Office Assistant.
Additional query words: permissions
Keywords : kbusage |
Last Reviewed: March 18, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |