Access 97 and <dbname> isn't an index on this table

[Diane Yocom]

Perhaps noone uses Access 97 anymore and this is no longer an issue, but I
just spent the day trying to troubleshoot a corrupted database that was
giving the following error and I wanted to post my solution just in case it
may be helpful to someone else:

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

If you look at the usenet archives, most of the suggestions centered around
three suggestions:
1) Download a tool called jetcomp.exe and use it to compact and repair the
database
2) Create a new database and try to import the tables from the corrupted
database
3) Restore from backup

None of these suggestions worked for me, but I was able to repair and
compact the database by opening up Access 2002 and using it's database
repair utility against the Access 97 database. It repaired it without
requiring me to convert it and I'm now able to get all my data again.

Hope this helps some other poor soul,
Diane Y

 

[gandalf]

Thanks for sharing the solution.

 

[Joan Wild]

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

None of these suggestions worked for me, but I was able to repair and
compact the database by opening up Access 2002 and using it's database
repair utility against the Access 97 database. It repaired it without
requiring me to convert it and I'm now able to get all my data again.

Thanks for posting Diane. Glad you got it working. FYI, Tony Toews has
lots of information on his website about corruption.
http://www.granite.ab.ca/access/corruptmdbs.htm

Both the symptom you encountered, and the resolution you found are there.

 

[Tony Toews]

If you look at the usenet archives, most of the suggestions centered around
three suggestions:

0) Ensure you have Jet 3.5 SP 3 installed.

1) Download a tool called jetcomp.exe and use it to compact and repair the
database

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm