diamondDog
New member
- Local time
- Today, 04:36
- Joined
- Sep 18, 2024
- Messages
- 26
As I understand it, for a user to be able to create/edit a linked SharePoint list record through an Access form, they would need to have Contribute-level access on that SharePoint site list. If this is true, is there a way to grant users this SharePoint list access on the SharePoint site but also block/prevent them from just bypassing locked Access form fields and just go directly to the SharePoint list itself to make edits on any and all fields they wish?
I want to use Access as a front-end to have different groups of users be able to edit only certain fields (through different Access forms) but I would need a way to prevent these users from just going directly to the SharePoint list form to update any field they wish.
Is there a way to do this?
I want to use Access as a front-end to have different groups of users be able to edit only certain fields (through different Access forms) but I would need a way to prevent these users from just going directly to the SharePoint list form to update any field they wish.
Is there a way to do this?