Share via

Data Cannot be inserted.

Anonymous
2015-10-18T06:19:54+00:00

Occurs in Access 2013 and Access 2016 with lists within Site Contents. (Office 365)

When attempting to add data to a particular field in an access list on Access 2013 desktop, I get, "Data cannot be inserted because there is no matching record." All other fields accept data, however, I did receive that error when I created another field within that same list. It only occurred in one record.

Upon googling for an answer I found a possible solution and that was to refresh lists of related tables.

Upon doing that I received, "You do not have the necessary permissions to use the " object. Have your system administrator or the person who created this object establish the appropriate permissions for you."

I am the creator of the object. I am global admin on Office 365.

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ScottGem 68,830 Reputation points Volunteer Moderator
    2015-10-18T22:25:58+00:00

    Can you show us your Relationships diagram?

    How are you adding the data?

    Was this answer helpful?

    0 comments
  2. Anonymous
    2015-10-18T22:12:29+00:00

    No, desktop version.

    thanks

    Was this answer helpful?

    0 comments
  3. ScottGem 68,830 Reputation points Volunteer Moderator
    2015-10-18T14:23:02+00:00

    The error message sounds like you have a relationship imposed and are trying to insert an orphan record. 

    Is this an Access Web App?

    Was this answer helpful?

    0 comments