MS Access 2010 to SharePoint 2010 error: Data cannot be inserted because there is no matching record.

We saw the below error message, when I try to update a record in SharePoint 2010 List which is linked up with MS Access 2010. I have 100s of records out of them only one record is giving us this error message. 

Error: Data cannot be inserted because there is no matching record.

In the MS Access if I go to the Linked Table (SharePoint List in MS Access) and just modify the record (uncheck and check a status record and revert it back), then everything works fine. It seems that particular record was not syncing with Server SharePoint List item/record.

Instead what I did is, I went to the table in MS Access, Right Clicked on the table and More Options than clicked on Relink Lists. Then it worked. I saved this version of MS Access db as new version and send across to the user.

http://stackoverflow.com/questions/3791372/data-update-error-with-sharepoint-2010-and-ms-access-2010

Cannot complete this action as the Secure Store Shared Service is not responding. Please contact your administrator.

While configuring the performance point 2010 I got the following issue

Cannot complete this action as the Secure Store Shared Service is not responding. Please contact your administrator.

After trying many approaches, I found the solution

1. Make sure the SecurityTokenServiceApplicationPool is running.

2. Go to System Settings -> Manage services on server

Following services should be enabled

PerformancePoint Service

Secure Store Service

Claims to Windows Token Service

3. Go to Application Management -> Manage service applications

4. Check the Secure Store is started

5. Go to App-pool and make sure the the associated App pool is running

6. Reset the IIS

SharePoint : Limited Access

Microsoft:

The Limited Access permission level is designed to be combined with fine-grained permissions to give users access to a specific list, document library, item, or document, without giving them access to the entire site. However, to access a list or library, for example, a user must have permission to open the parent Web site and read shared data such as the theme and navigation bars of the Web site. The Limited Access permission level cannot be customized or deleted.

 NOTE   You cannot assign this permission level to users or SharePoint groups. Instead, Windows SharePoint Services 3.0 automatically assigns this permission level to users and SharePoint groups when you grant them access to an object on your site that requires that they have access to a higher level object on which they do not have permissions. For example, if you grant users access to an item in a list and they do not have access to the list itself, Windows SharePoint Services 3.0 automatically grants them Limited Access on the list, and also the site, if needed.

Click here to see more --> on this.

So don't delete Limited Access permissions from your site as it wont harm you or your site.