'Id' is not an index in this table - MS ACCESS

I am getting errors in Access when attempting to open both the database and the table.

Error: 'Id' is not an index in this table

Please help me, this is in production.

May Anyone Please share their expertise if come across with same scenario

2 Answers

It means that database corrupted. Try to restore database as it described here. Also check this, item 20 and this. And finally check how to prevent corruption.

I also had this error message. Unfortunately the links provided by Sergey only helped in so far as that it became clear to me that my Current DB was unrecoverable.

I fixed the issue by:

1. Creating a new Access DB
2. Manually exporting each table from the old one (Access still allowed me to export to another DB, eventhough I got the error message on each and every export)
3. Recreating all necessary relationships between tables in the DB

Note: This solution worked well for me because the error appeared in the backend of my DB. If you have an unsplit DB, this could be a huge effort.