Wednesday, February 10, 2010

Workflow for Access

Task:
Assign permissions based on field values, i.e. ColumnName: Person name; Value: Semicoln seperated user names; PermissionValue: Contribute
Each item gets permission based on the above field values.

Idea 1:
Create eventhandler

Idea 2
Use workflow.
Association data - List of fields
- Permission values
Workflow get initiated every time an item is updated or added.
Uses association data and toggles permissions on the item.

No comments:

Post a Comment