R – Access Services and SharePoint 2010 – Need Info

Check whether UAC (User Account Control) is on and turn it off if this is a test/demo environment. The other option (and the best option for Production environments) is to right click the central admin link and choose the option to 'Run as Administrator'.

I got burnt by this for a little while and the reason is because of the way the security check is performed before the solution deployment job runs. If you are running with UAC enabled then this check will always fail (see the Remarks section on MSDN for system.security.principal.windowsprincipal).

I determined the problem. As I was manually editing some more records in the "unfiltered" view of my SharePoint list, I found that the occasional record would still not update and throw the same error.

I happened to notice the records that would not update had another column set, which was a lookup column (you're right, Remou). But oddly, the ID value was displaying and not the lookup value. This didn't make sense, as MS Access had also linked all related lists.

I opened up the appropriate lookup list only to find Access was not retrieving any of the values. This again was odd, because the values existed in SharePoint, and the lookup relationship was intact were you to edit the same record in SharePoint. I couldn't force Access to update or fix its connection to the list.

I ended up deleting the lookup SharePoint list and recreating it. This solved the MS Access problem.