Windows Forum

Ask something
Discussion Locked

Access 8.0 repair

0 helpful
4 replies

by wessir

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Unfortunately our network has been failing lately, taking Access with it. After restoring the network connections I find Access has been corrupted, when attempting to repair using tools:database utilities:repair database the message "XXX is not a valid index, check the tabledef object..." The database window cannot be displayed although the forms and reports continue to function. Even though the data is still there I can't recover the tables and must restore from a backup. Is there some other way to get the data? I have tried importing it from another Access database but I get the same message.

4 replies

by kkenkel513

Indexes are recreated during the Compact function. Open the database, click on Tools, Database Utilities, Repair and Compact database. That should take care of the problem.

by portertech

Restore from backup is your best option. Aside from that, as you are experiencing, repair / compact will not clean up your problems. However, if your forms and tables still function, then they are accessing the data, and we can assume it is still there. Try 2 things: (1) attempt to link to the tables from another mdb file and use a SELECT * INTO newtablename FROM linktablename. or (2) Using the corrupt mdb file, create a SELECT * FROM badtablename, and if all the data displays, use ctrl+Ato select all records, open a spreadsheet, and paste it in. The second choice can take a very long time, but you will have the data back then get to work putting it back into access. Good Luck

This discussion is closed to new replies.