Results 1 to 1 of 1
  1. #1
    Join Date
    Jan 2004
    Bratislava - Slovakia

    Unanswered: Pivot Table filtering


    I'm working in MS Access 2002 Developer Edition

    I'm preparing a database "Customer Information System" for my collegues:
    25 users in 4 countries in 5 languages; replication via Intranet.
    Everything works fine, but ...

    I've a new comp, where I copied all files from the old one
    There are 3 PivotTables with same query source
    Two of them I'm able to filter and one not. Why?

    In the run-time version, there is not possibility to filter them, however Microsoft HotLine (Slovakia) sais:
    There are no restrictions according filtering in the run-time version of MS Access 2002.

    (To filter a PivotTable means: control the content thru "Field drop-down arrow" only.(for me; in this case))
    See attached GIF picture.

    The problem is most probably somwhere in Security/Permisions.

    Could you help me please?

    To make my questions simple:

    1. Where in Access I can allow/disallow the PivotTable filtering for the user?
    2. Do you know about restrictions in run-time version of Acccess according to PivotTable filtering?

    Thanks for any idea.

    Attached Thumbnails Attached Thumbnails pivot01.gif  

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts