Access 97 DB opening error: 'C:\my.mdb' isn't an index in this table. 1

[myvision69]

When I open the Access 97 DB in Access 97 I get this error:

'C:\my.mdb' isn't an index in this table. Look in the Indexes collection of the TableDef object to determine the valid index names.


How can I fix this be be able to see all the tables and data?

Thanks for prompt reply.

 

[lameid]

Step 1 whenever something bad happens... Make a backup copy.

Next try repairing the database by selecting the Tools Menu, database Utilities and Repair database.

If that doesn't work, you can try decompliling the database (I doubt it will help in this case but if it does I'd be interested to hear about it).
From the run menu in the windows start menu copy and paste the below changing for your database file and installation directroy of office if you did not use the default:

"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "C:\YourdatabaseFolder\YourdatabaseFile.mdb" /decompile

Lastly try importing everything into a new database folder.
If it acts the same, try importing a group of objects at a time to try isolating the problem object. Once you get it down to an object decide how best to recover it. Hopefully you can import from a backup at this point.

If you're still stuck, I hope you have a backup as I'm out of ideas.