Tool to recover & repair a corrupted *.MDB database (Access).

views:

171

answers:

Tool to recover & repair a corrupted *.MDB database (Access).

Over the years I have seen many errors on corrupted Access *.MDB files.
I do not use Access as frontend, just as backend to store data Tables.
I already use the best practices: normalization, close the database connection ASAP, etc.

I was wondering if somebody knew which the best commercial tool to recover data from a corrupted MDB file is. (I need a tool, not a service).

I have seen AccessFix, Access Recovery, Advanced Access Repair.
Have you used any of these tools? Any winner? Any recommendation? Any advice?

Thanks,
Jag

P.S. I know I shouldn’t be using an Access backend on a concurrent user & network environment, but there is nothing I can do right now.

+2 A:

Since I started professional Access development in 1996, I have only once had a corrupted MDB that required anything other than the built-in compact/repair tools. In that case, I used Peter Miller's PKSolutions. And in that one case, the corruption was my fault -- I killed the Access process while it was running a large update.

David-W-Fenton 2009-04-29 20:20:09

I think I can add a few years to that, and though I would not claim to be a professional developer, I, too, have only seen one very badly damaged mdb, and that was on a badly damaged computer, and the data was recoverable.

Remou 2009-04-29 21:00:28

I didn't was this question to be a commercial... so I will just say that the 3 products work great. AAR is the best at recovering data. And I found that the other two work great at recovering modules and stuff I didn't need since I just use Access as a backend.

2009-05-08 17:24:00

By the way... I got great customer support from AAR and AccessFIX. I didn't get an answer from Access Recovery. And I didn't contact PKSolutions since I wanted a tool, not a service. Thanks anyway David, I'll mark this “as the answer” since I wanted a comment/suggestion and not an absolute truth.

2009-05-08 17:29:57

There is a tool called Advanced Access Repair. I have used it to repair many corrupt Access MDB files on my damaged disks successfully. Its homepage is http://www.datanumen.com/aar/

Wangdong

wangdong 2010-03-06 07:16:07

The fact that you've just joined SO and posted two answers to questions about corruption that recommending the same tool suggests you're shilling for your employer or your own product. If you have an interest in this product, you should declare that.

David-W-Fenton 2010-03-06 17:25:35

ansaurus

tags:

views:

answers:

Tool to recover & repair a corrupted *.MDB database (Access).

related questions