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

6

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.

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password

Post as a guest

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.