"Id is not an index in this table"

  • Thread starter Thread starter Ang
  • Start date Start date
A

Ang

My database was working fine until earlier today when my computer locked up
just as I was finishing entry of a new record. Since that point, I am unable
to open my database and get the above message (error 3800). Is there a way
to fix this error?- I am using Access 2007.

Thanks in advance...
Ang
 
Ang said:
My database was working fine until earlier today when my computer locked up
just as I was finishing entry of a new record. Since that point, I am unable
to open my database and get the above message (error 3800). Is there a way
to fix this error?- I am using Access 2007.
Click to expand...

This can be a sign of corruption.

IMPORTANT - Make a copy of that file.

Then open up Access 2007, click on the Office button, upper left hand
side, >> Manage >> Compact and Repair Database. Now try that on the
database.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
Ang said:
I continue to get ths same error when I try to compact and repair the
database.
Click to expand...

Ok, definitely corruption then. Can you try importing from that
database? How good are your backups?

For more information on corruption including retrieving your data,
links, official MS KB articles and a list of vendors who state they
can fix corruption see the Microsoft Access Corruption FAQ at
http://www.granite.ab.ca/access/corruptmdbs.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
My backup was about a week old and missing many records unfortunately.
However, I was able to export my data from the corrupt database to an Excel
spreadsheet, and then import it back into a new database. At least I dont
have to reenter so much work. What causes it to corrupt just like that?
Perhaps I can prevent it from happening again. Thanks for your help and your
suggestions.
 
Ang said:
What causes it to corrupt just like that?
Click to expand...

The database corrupted because your computer because your "computer
locked up just as I was finishing entry of a new record". Why it
locked up I don't know other than to think you might have a failing
hard drive. I'd go looking in the Control Panel >> Administrative
Tools >> Event Manager for problems.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
Back
Top