The error "Id is not an index of this table"

Mariana Melen 0 Reputation points
2025-11-22T18:13:36.01+00:00

User's image

I have a problem, when I open files or close or open a form in my file I get the error ""Id" is not an index of this table". I also have tables and queries there is no such error.
Microsoft 365 and Office | Access | For education | Windows
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Marcin Policht 68,300 Reputation points MVP Volunteer Moderator
    2025-11-22T18:37:21.95+00:00

    Refer to https://www.stellarinfo.com/blog/fix-ms-access-error-id-is-not-an-index-in-this-table/


    If the above response helps answer your question, remember to "Accept Answer" so that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.

    hth

    Marcin

    0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.