If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
mdb Repair Utility?
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 |
#2
|
|||
|
|||
mdb Repair Utility?
"Jacob Havkrog" wrote:
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/Compa.../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/ |
Thread Tools | |
Display Modes | |
|
|