Access 2007 error 3800 'ID' is not an index in this table

I'm working with Access 2007 and have never had this issue, but it's causing me MAJOR headaches. . .whenever I open my DB, this message pops up with a button for OK or Help.  Help does nothing and if I hit OK, I have to use Esc to get through the number of records I have with this issue until it's gone through the whole DB. 

Then sometimes (but not everytime) I get a message that says "The database cannot be opened because the VBA project contained in it cannot be read.  The database can be opened only if the VBA project is first deleted.  Deleting the VBA project removes all code from modules, forms and reports.  Your should back up your database before attempting to open the database and delete the VBA project."

So, I click ok, then I get a message that says "The Visual Basic for Applications project in the database is corrupt."

This is a brand new DB, so I'm not converting it from 97 to a newer version and if I try to run Compact and Repair, the program won't let me and I end up in a vicious cycle that I can't get out of.

Access 2007 has been uninstalled and re-installed on my PC. 

All was semi-OK until I created a report.  It's a basic report, no sums, nothing fancy, and now I can't even delete it.

 

 

Question Info


Last updated September 9, 2019 Views 29,863 Applies to:
Answer
Answer

MAKE A BACK-UP

Sounds like the begining of corruption (See item 20)...
http://www.granite.ab.ca/access/corruption/symptoms.htm.

I would make a back-up, make another back-up and then first try importing everything into a
new database.  Also, read this article...
http://www.granite.ab.ca/access/corruption/retrievedata.htm.

And after all of that I would finish off with this article...
http://allenbrowne.com/ser-25.html and see if any of those circumstances apply to you.


--
Gina Whipp
2010 Microsoft MVP (Access)

Please post all replies to the forum where everyone can benefit.
Gina Whipp
Microsoft MVP (Access 2010-2015)
https://www.access-diva.com/tips.html

2 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.