id is not an index in this table

[Brent]

I have been working with this database for several years. I now have an error
that comes up "id is not an index in this table".
I have tried making a new database and importing the tables to start over
again. Then it will pop up again. Help!
thanks,

 

[Jerry Whittle]

Have your also tried a compact and repair?

When does this happen? Can you narrow down the table?

It may be that importing the problem table(s) doesn't prevent the problem
from being imported. Maybe link to that table in a new database then use a
make table query on it to recreate the table with fresh records.

 

[John W. Vinson]

I have been working with this database for several years. I now have an error
that comes up "id is not an index in this table".
I have tried making a new database and importing the tables to start over
again. Then it will pop up again. Help!
thanks,

You have a corrupt index in the table. MAKE A BACKUP OF YOUR DATABASE AT ONCE,
you may need it!!!!

Then see the suggestions at:


http://www.granite.ab.ca/access/corruptmdbs.htm or
http://allenbrowne.com/ser-47.html

I've seen this particular (misleading) error message and it indicates some
pretty severe problems.

 

[KARL DEWEY]

I now have an error that comes up "id is not an index in this table".
When does it occur? Check the SQL or properties of whatever is moving at
the time of the error.