How do I fix corrupted Access databases  2002 when error 'AOIndex is not an index in this table' displays?

Posted on 2003-02-19
Medium Priority
Last Modified: 2012-05-04
How can I repair databases when  Error 3800 'AOIndex is not an index in this table' displays when trying to open the database.  I have several students in a beginning Computer Science 101 class that have corrupted databases.  Access Compact and Repair utility does nothing and just returns the same "'AOIndex' is not an index in this table" error.  I tried the suggestions on Microsofts Knowledge base but no luck.  Jetcomp.exe did not fix the files either.

What causes the error to occurr and how can it be corrected and then prevented?
Question by:southerner
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Accepted Solution

wenyonk earned 100 total points
ID: 7985042
I dont know about the error, but it is possiblethat you have a corrupt (hidden) system within the database.

Have you tried to open/create a new blank database (db1) and then from the file menu select Get external data, then select import.  Select your problem table and import all the objects from each tab.


Assisted Solution

dleongvp earned 100 total points
ID: 7985592
Access databases can be easily corrupted and non-recoverable if the database is not closed normally due to a power outage, user pressing ctrl-alt-delete, or ending the task using task manager, or an OS freeze, or turning off the computer with the off button, while the database is open.

Having a backup copy of the database is the best insurance and storing the data tables in a separate database from the application or queries database will help.

I did find one fairly fool proof method to protecting an Access Database from being corrupted by users.  This can be done by having at least computer with the database open at all times, or at least until all users have left.

Having one person/user with the database open prevents the database corruption in my experience (have never lost a database since I started doing this).  If the database is open and the system is unresponsive to the keyboard, you should open the database on another machine.  If the keyboard works, you open the database on the same machine in a new window.

Good luck,

LVL 18

Expert Comment

ID: 8691183
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
Accept question, split points to wenyonk and dleongvp
Please leave any comments here within the next seven days.
EE Cleanup Volunteer

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question