"Id is not an index in this table"

[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

 

[Tony Toews [MVP]]

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.

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]

I continue to get ths same error when I try to compact and repair the
database.

 

[Tony Toews [MVP]]

I continue to get ths same error when I try to compact and repair the
database.

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/

 

[Ang]

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.

 

[Tony Toews [MVP]]

What causes it to corrupt just like that?

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/