Hi,

I have got a PivotTable in Data Access Page. I want set access(read-only/read-write)for each columns in PivotTable.

For example:

I have got a table with four atributes (name, age, city, PLZ). These columns are
display in PivotTable and users can edits and deletes all data. I want set access
like this: name:read-only
       age:read-write
       city:read-only
       PLZ:read-write

I'm trying this:
    PivotTable0.ActiveView.DataAxis.FieldSets("name"). View.AllowEdits=false
PivotTable0.ActiveView.DataAxis.FieldSets("name"). View.AllowDeletions=false
PivotTable0.ActiveView.DataAxis.FieldSets("age").V iew.AllowEdits=true
PivotTable0.ActiveView.DataAxis.FieldSets("age").V iew.AllowDeletions=true

but it's not work correct.

Can anybody some ideas, how to solve this problem?

Thanks you very much for each idea.

harmony82