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.

  • Answer Accepted: No
  • Question Category:
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.

About Tim Lahaye
Questions
3
Answers
256
Best Answers
20
  • Posted on -
  • Question Category:

The application was unable to start correctly (0x000007b)

Previous

Corel Video Studio has encountered an unspecified error

Next

Related Questions