Pivot table permissions issue

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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,

I know this seems a little strange but i to am having this problem. However
im not sure what your meaning when logging in as a user. When i log in as the
writer of the database i am unable to change the selected fields required in
my pivot table.

I have not set up user or admin priveleges anywhere and i find this problem
very confusing.

Could you clarify what i would possibly need to check in order that i can
fix this problem.

Thanks for any help
 
When you say you are logging in "as the writer of the database" do you mean
you are simply opening the DB or are you being presented with a log in dialog
box asking for or name; a password; or both?

Every Access database has security and permissions on it. By default when
you create a new data base Access sets up an Admin user and adds it to both
the Admins and Users groups. From that point on every time anyone opens the
database Access assigns full permissions to the user treating them as Admin.
So; if you have not changed or modified the security you should have full
permissions on all objects including your pivot table. Try checking the
permissions for the Admin user first.

Back up your database first.

Open the database. Go to Tools/Security/User and Group Permissions. Be
very cautious actually changing anything! You might lock yourself out of
your DB. Using the Object Type combo start with the Database object and note
carefully if the Admin user has Administer rights check off. Go through each
object type (i.e. Tables/Forms/Queries etc.) and note if Admin has Administer
rights on all the objects.

Pay close attention to the Pivot table form you are having difficulty with
along with any underlying tables or queries the form references. Do you have
Administer rights on all the objects. You must at least have Read Design and
Modify Design on the Pivot Table form to enable users to write changes to
the filters in the drop down lists.

Hope this helps.

Rick in N S
 
When i open the database i just get a screen that warns me about macros and
the like. I then click open holding down the SHIFT key in order to allow me
full access.

However even when i do this i cannot change the selections made by others in
my pivot tables.

The strange thing is that the pivot tables that i cannot change are looking
at the same query as a couple of other pivot tables, but these other pivot
tables allow me to change the selections as required. I have checked the
rights allowance and all seems well, but there are two users, Admin and
Myself.

When im writing a database would it be that i am Myself, or Admin? I know
some of the observations that i make may seem a little vague and ambiguous
but i am clutching at straws here and dont know where to go. I have written a
number of other databases that do very similar things to this one and all
works fine and i am a little lost

Any help is greatly appreciated.

Cheers Rick
 
It appears rights and security levels have something amiss that is affecting
the performance of some of the tables. If permissions are incorrect any
changes can't be written to the pivot tables. Check the underlying query's
properties to see if the query has Run Permissions set to "Owner's" or
"User's" and compare the configuration with pivot reports that do work.

Try writing a new query on the same tables that are used by the
malfunctioning pivot tables and create a new pivot table report based on the
new query. Does it run as expected?

It is hard to answer your question about "Admin or Myself" without having
some insight into how the start up code is written. Check the "on open" and
"load" event on the initial form you see when you open access what the VB
instructions are.
 
Back
Top