'AOIndex' is not an index in the table

[J]

Hi,
my microsoft access file would not open. i get the following error message:

'AOIndex' is not an index in this table

i have tables, forms and reports in my access files.

i have tried the jet compact utility program and it does not work.
please can you help me.

Thanks.

 

[jlute]

Hi,
my microsoft access file would not open. i get the following error message:

'AOIndex' is not an index in this table

i have tables, forms and reports in my access files.

i have tried the jet compact utility program and it does not work.
please can you help me.

Thanks.

Maybe try opening a blank database and importing everything into it...?

 

[aaron_kempf]

Move to SQL Server.

Access isn't reliable enough to 'keep it up' if you know what I
mean

-Aaron

 

[Tom Wickerath]

Hi J:

Sorry to have to tell you this, but this is a sign of database corruption.
The good news is that Dirk Goldgar has come up with a fix for this issue. See
bullet # 20 here:

http://www.granite.ab.ca/access/corruption/symptoms.htm


Good Luck!


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________