Index error when opening an Access database

C

Chuck Anderson

I have an Access database tahat was sent to me for
recovery. I have tried Importing it to a New database,
used the recovery tool tool Jetcomp provided by Microsoft,
and tried compact and repair. But nothing works. The
error I get is "AOIndex"is not an index in this table. It
comes up twice then just fails to open. One last thing,
since this is not my database, I also tried holding down
the [shift] key when opening thinking maybe there was
something executing failing before the open. But, no
luck. I would appreciate any help. Please email me at the
above address.

Who gives a shit what an index to a table is, open the
damn database.

Desperate in Detroit!
 
S

StCyrM

Hi Chuck

This is an MDB and not an MDE file, right?

If it is an MDB file you can try the Decompile as follows:


1. Create a backup copy of the MDB file while Access is not running.

2. Decompile the database by entering something like this at the command
prompt (one line, including the quotes):
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\My Documents\MyDatabase.mdb"

3. When the database opens: Tools | Database Utilities | Compact.


Hope this helps.

Maurice
 
Top