title: Data update error with SharePoint 2010 and MS Access 2010
body: <p>I've encountered a strange error when attempting to update a SharePoint 2010 list that I have linked to via Microsoft Access 2010.</p>
  
  <p>Error: Data cannot be inserted because there is no matching record.</p>
  
  <p><img src="https://i.stack.imgur.com/NSfhw.png" alt="Microsoft Access - Data cannot be inserted because there is no matching record."></p>
  
  <p>This occurs in 2 scenarios:</p>
  
  <ol>
  <li>I attempt to run any UPDATE query against the list in MS Access</li>
  <li>I attempt to update a record from the list if the list view is filtered</li>
  </ol>
  
  <p>The second item might need an explanation. If I simply open the linked list in Access, scroll down to a record I want to edit, and edit it, it works. If I filter that view first (for example, showing only records with a checkbox field checked), I cannot edit any records and get the error.</p>
  
  <p>This only happens in one particular environment; others work fine with either approach. I've checked permissions (I have full control of the list, I am a Site Collection Administrator, etc.). I have tried linking to the list in various ways: from within Access, from the "Open with Access" ribbon button in SharePoint. I've deleted and recreated the Access DB file... no luck.</p>
  
  <p>Also, Google has no knowledge of this particular error: searches for the exact error text come up with 0 results.</p>
  
  <p>Any idea what to check? Running SQL-style queries against this SharePoint list is the only viable option for maintaining it.</p>