ACC: User with Full Permissions Cannot Change a Query (95328)
The information in this article applies to:
- Microsoft Access 1.0
- Microsoft Access 1.1
- Microsoft Access 2.0
- Microsoft Access for Windows 95 7.0
- Microsoft Access 97
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.
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.
| Modification Type: | Major | Last Reviewed: | 5/28/2003 |
|---|
| Keywords: | kbprb kbusage KB95328 |
|---|
|