I use MS Access 2010 with ADP to update sql database.
I wanted to partition some table using views and provide update permissions on each part to different user. Problem I have is that even when Access is set to work on a view it issues update on the source table causing "no permissions" error.
Is it possible to force Access to issue update on a view itself?
ADP is deprecated, and not supported anymore since Office 2013.
It uses ADO and one if it's con is the issue you are experiencing: on Views, ADO has the bad habbit to try to access the underlying Tables instead of staying at View level, thus permission error in your case.
There's nothing you can do apart coding passthrough UPDATE queries or use ODBC Linked views.
But the best thing you can do is moving to accdb project with full ODBC linked tables, you'll have to do that at some point anyway