Data cannot be inserted because there is no matching record

Asked By Geoffrey P Stouffer 0 points N/A Posted on - 02/21/2014

Hi Professionals,

I have a problem with Microsoft Access, I think. When I try to update a record in SharePoint 2010 List connecting with Microsoft Access 2010 I ended up with an error message. This is not happening often; in rare case I see this error. How to solve this error? Please help me to fix the error.

 

 

MS Access

Data cannot be inserted because there is no matching record.

• Status: Open
• Question Views: 4404
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Access

Answered By Tim Lahaye 10 points N/A #194468

Data cannot be inserted because there is no matching record

The error normally occurs because when access tries to update the non-lookup fields, it ran its own integrity check where it finds integrity error. This sometimes may contribute because of UserInfo table (Internal lookup table) which can be updated from more options within access and then clicking the Relink-list. You need to open the lookup list especially from within access.

About Tim Lahaye

Questions
3

Answers
256

Best Answers
20

• Vote Up 0 Vote Down

• Posted on - 02/21/2014
• Question Category: MS Access