Data cannot be inserted because there is no matching record

Asked By 0 points N/A Posted on -
qa-featured

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.

SHARE
Answered By 10 points N/A #194468

Data cannot be inserted because there is no matching record

qa-featured

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.

Login/Register to Answer

Related Questions