Index error when opening an Access database

  • Thread starter Thread starter Chuck Anderson
  • Start date Start date
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!
 
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
 
Back
Top