MS Access – corrupt db?

Factual Questions
1

I have a bad feeling that I may have a corrupt database on my hands.
When I try to open my db I get the following error message:

Db1.mdb isn’t an index in this table. Look in the indexes collection of the TableDef object to determine the valid index names.

Is there a way to recover this file or am I out of luck? :smack:

2

Does it finish opening after that? If so, you may be able to fix it.

If not, you could try opening it from a different computer. One with a higher version of Access may be able to recover the data.

3

No, it won’t open at all.

I’ve tried opening a new, blank database And copying the tables but that generates the same message.

4

First try to get the jetcomp.exe utility, google for it, and run it against your db. If that doesn’t work, and you’ve already tried to import the tables, etc., go to plan b, decompile.

5

Thanks BF - I tried both of your suggesytions and I’m still stuck.

Any other options?

6

When you open a blank db, do you import or copy from the affected db?

7

I’ve tried both - no luck :frowning:

8

I don’know jack about Access but I do work with DBs all the time. I do not know if this has any chance of working.

[WAG] Are there actual index files for Access? If so, you might want to try renaming the index files and running a reindex/compact or whatever database utility Access has. [/WAG]

Or, with a little googling I found this tool, which appears to have one free trial. Note, I don’t know jack about the tool so I cannot vouch for it in any way.

Slee

9

Sometimes it can be a single table causing the problem. Have you tried this:

  1. Create the blank database and import a single table into it.
  2. Open the file. If no error, continue with each table one at a time.
  3. When (if) you find the offending table, recreate the table by scratch (that is, the design).
  4. Import the data only from the offending table.

Sorry, I can’t guarantee this, but it’s worked in the past for me.

10

JFTR: Access doesn’t store any of its objects as discrete files; they’re all packed into a single .mdb file (well, plus a lockfile)

11

What version of Access are you using? If 97 then see the following…

From Some Microsoft Access MDB Corruption Symptoms:

Jet 3.51 can be downloaded from here. Even if you are not using Access 97 give it a try.

12

Thanks for the suggestions, but unfortunately nothing has worked.

I guess it’s a darn good thing I do regular back-ups! :smiley:
At least it’s only one day’s work down the tubes :rolleyes: