MS Access "id" is not a valid index

When I try to open my access database I get an error that says id is not a valid index.

I did not change the开发者_StackOverflow中文版 layout of the database at all. The database is live on a website and it is able to edit and add to it without a problem.

What can I do to open the database?

I had the same issue and found this on Internet. It may help you You can do following approach

At first, I tried to “Compact and Repair” the database. That didn’t work. Next, I tried creating a new database and importing the tables, forms, reports and queries from the corrupted database. When I tried the import, I just got a bunch of “ID is not an index in this table” messages and nothing more. The import would stop at this point.

What eventually worked was to open the corrupted database and manually export each object from the corrupted database to a brand new database. I was able to do this with the export tools in the ribbon bar and by selecting “Access” as my export option. I did have to create the new, blank database first; the database to export all of the data to.

Unfortunately, I could only export one object at a time. So it took a while to do;

Answer Source : "http://www.lmhproductions.com/237/microsoft-access-id-is-not-an-index-in-this-table/"

Thanks

Do you have special keys enabled? You may try skipping startup routines if there are any. You do that by holding shift key while starting. Once you get it opened you may be able to repair it. It sounds likely there is a corruption of a table index. You should backup and be sure to keep any old backup handy as well. If you can, try compact and repair on a copy then the usual round of corruption Hail Marys.