RE: Pivot table permissions issue
From: Rick (Rick_at_discussions.microsoft.com)
Date: 12/22/04
- Next message: Rick: "RE: Access 97 Security issue Can't make a MDE"
- Previous message: '69 Camaro: "Re: Access 97 Security issue Can't make a MDE"
- In reply to: Rick: "Pivot table permissions issue"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 22 Dec 2004 05:33:03 -0800
For the benefit of others who may have encountered this problem I have
finally answered my own question after several hours of research and testing:
The user must have permissions set to permit opening the database
exclusively in order for any changes to the data selection to be saved with
the pivot table design.
Additionally, in a split database check the permissions on the back-end
tables AND on the front-end links to assure the user has the correct
permissions.
"Rick" wrote:
> I have a pivot table form based on a query on several tables. The pivot
> table form once opened presents a drop down at the top permitting the user to
> tick off which weeks they want to see displayed. Any Admins user can open
> the form; change the weeks to display; close the form; open the form and the
> display is now of the weeks last chosen.
>
> However; any user who is not a member of the Admins group is unable to
> retain the last weeks chosen once the close the form. Next time they open
> the pivot table it displays not the last weeks chosen but the ones prior to
> the last time changed.
>
> This obviously has something to do with security permissions although the
> non Admins user receives no warning they are restricted from changing the
> weeks data to be displayed. Once they change the weeks the form refreshes to
> display their changes. However; once closing the form and opening it the
> data displayed is not the last choices.
>
> I have attemted to narrow down the problem by logging on as a non Admins
> user and running the underlying query. Data changes via the query are
> immediate and uneventful. It is only when the non Admins user attempts to
> make changes on the pivot table form that data changes are non effective.
>
> I have checked permissions on the pivot table form to assure they are the
> same as the underlying query. Still the form does not permit permanent data
> changes.
>
> What am I doing wrong?
- Next message: Rick: "RE: Access 97 Security issue Can't make a MDE"
- Previous message: '69 Camaro: "Re: Access 97 Security issue Can't make a MDE"
- In reply to: Rick: "Pivot table permissions issue"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
