Share via

access database engine cannot find record

Anonymous
2013-02-11T09:04:06+00:00

Hi,

I have created an access database and form off the back of a template. However i have had to rearrange the fields. This led to me removing a number of fields, and replacing with my own. However now when i click to go to the next record i get the following error:-

The Microsoft Office Access database engine cannot find a record in the table 'Contacts' with key matching field(s) 'Opened By'.

This is odd as none of the fields reference the table Contacts any more. My Access knowlegde is very basic so any help is really useful.

Thanks in advance

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

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ScottGem 68,830 Reputation points Volunteer Moderator
    2013-02-11T13:13:12+00:00

    If this was a 2010 template, I suspect there may be a data macro referring to the table.

    Was this answer helpful?

    0 comments