HELP: AOIndex is not an index in this table.

[Aimee]

I need help with an Access 2000 file. When I try to open
the file, I receive this error message "AOIndex is not an
index in this table." This occurs after I enter my
password. The file never opens. I can open other files in
Access without problems. Any suggestions to resolve this
would be greatly appreciated.

Thank you.

 

[Joan Wild]

I suggest you copy the database first.

Try compacting your database using Jetcomp, available at
http://support.microsoft.com/?id=273956

If that fails, try creating a new database and importing objects from the
old.

If that fails, you can try www.pksolutions.com

 

[Tony Toews]

I need help with an Access 2000 file. When I try to open
the file, I receive this error message "AOIndex is not an
index in this table."

Sign of corruption. See the Access Corruption FAQ at my website.

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