"not an index in this table" error

[everette]

I have a file somewhere that seems to be corrupted and I don't know what to do. "Id" is not an index in this table is the error message I'm getting.



Thanks
Everette

[Robeen]

Can you give us some more information about exactly what you do that gives you the error?
Code samples etc might help.

[pbaldy]

I changed the title of your thread to something more meaningful to future users than "Please help".

[everette]

I was just doing a compact and repair and this came up. I'm pretty sure it had something to do with a query that I wrote the other night. I was able to pull a table from this database and move it to a backup copy with out the query and it seems to be working fine now. I don't know what I did because I'm not using "ID" in any of my tables .
Thanks
Everette

[tanvi]

Hello Everette,


Good to hear that you have solved this issue. But as per my knowledge, this can be a sign of access database corruption. For other users who suffer with this issue first make a copy of corrupt file.


Check 20th article in following link to find out the cause & solution of the error:


http://www.granite.ab.ca/access/corruption/symptoms.htm.


I found one more blog on the same error:


http://data-base-recovery.blogspot.i...ion-error.html


Hope these solutions will help you!!