mdb Repair Utility?

[Jacob Havkrog]

Hi, I've got an mdb file with a table, that can't be opened.

Is says that the table "..." cant beopened, it might be an unknown database
or the file might be damaged (translated from Danish).

Access' built-in compact and repair cannot fix it. Neither can JetComp.exe

I've never seen this before. The user has been carrying the database file
around on a USB-stick.

OK, I did a quick google search and found the repair utility Stellar Phoenix
Access Recovery. The demo was able to open the bad table, so I bought the
product.

The full version quickly recovered the whole database.

But now, I realise that it didn't preserve referential integrity relations
between the tables. They are all gone. The same goes for text and memo field
settings "allow non zero length". And maybe other settings as well.

The product info or help didn't mention those shortcomings...


Can you recomend a better tool?

Thanks
Jacob

 

[Tony Toews [MVP]]

But now, I realise that it didn't preserve referential integrity relations
between the tables. They are all gone. The same goes for text and memo field
settings "allow non zero length". And maybe other settings as well.

You could try using the following tool and compare the tables, fields
and relationships between your last known good backup of the file and
the recovered file.

Compare'Em
http://home.gci.net/~mike-noel/CompareEM-LITE/CompareEM.htm

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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/