News, links, downloads, tips and tricks on Microsoft Access and related

About Me Search
Name:Alex Dybenko

Location:Moscow, Russia

Monday, September 18, 2006

AOIndex is not an index in this table

Dirk Goldgar, Access MVP,  have recently made a procedure to fix "AOIndex is not an index in this table" corruption in Access database. This is what you can certainly to try in case you get such error.


Anonymous Anonymous said...

I have face the following problem in Access. Please give me the soulation.

"AOIndex is not an index in this table"



6:39 AM  
Blogger Alex Dybenko said...

have you followed Dirk's advice?

8:34 AM  
Anonymous Anonymous said...

Hi, Alex.-
Thank a lot, This procedure is very invaluble, I had that problem and I could fix it.

10:55 PM  
Blogger Dave said...

I tried the fix for this and couldn't get the module correct. It keeps giving me "compile error" identifier expected when I put the "path to my database". I tried putting the path alone then the path including the DB name then with and without quotes. Can ANYONE please give me a clearer explanation of that routine. maybe an ACTUAL example. I would VERY much appreciate any help. I can also be emailed directly at:

administrator AT

I'm in desperate need of help to rescue a DB. I am using Access 2003.
=Dave R.=

10:07 AM  
Anonymous Matt said...

A great procedure that fixed my problem right away. A lifesaver!

9:58 PM  
Anonymous Georg said...

Unfortunately, this procedure doesn't work for me under Access 2007.

I ran the proc, but was not able to open the database after that.

Could it be that the proc needs to be updated for Access 2007 use?

Georg (oehl at

9:01 PM  
Blogger Alex Dybenko said...

Sorry, not sure it was updated for 2007

10:38 AM  

Post a Comment

<< Home