• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 293
  • Last Modified:

Advise on Best Free or Paid MS Access Database Repair Tool

Hi Everyone,

Can anyone advise on the best Free or paid MS Access Database repair tool

I have a database that has become corrupt and will not repair through the normal repair on opening with access

Thanks Adam
0
cdsaus
Asked:
cdsaus
  • 6
  • 5
  • 3
  • +3
9 Solutions
 
Wilder1626Commented:
HI

This one is free and can help fixing couple of errors or corrupted files on Microsoft Access dbase;
Stellar Phoenix Access Database Repair

If you are ready to pay, for me, this one is the best:
Ontrack File recovery
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Contact Wayne at

http://www.everythingaccess.com/accessdatabaserepair_info.asp

Hands down best on the planet - also an EE member.
If anyone can fix it, that would be Wayne :-)

Note he is in the UK ... so allow for time zone response, although rumor is Wayne never sleeps :-)

mx
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Agree with Joe: everythingaccess.com is the best out there for these sorts of things.
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
PatHartmanCommented:
I have found that occasionally opening the database with a different version of Access will "fix" the problem.  So, if you are working in A2010, try opening with A2007 or A2013.  If it is an .mdb file, try A2003.  I had a database in .mdb format that seemed to corrupt on alternate Tuesdays if the sky was clear.  We normally used A2010 to open it but we had some old computers around and opening it in A2003 frequently fixed the problem.  Of course, you have no options if you are using features available in only a single version.
0
 
cdsausAuthor Commented:
I have downloaded the Stellar Program although not free seems to say that it will recovery it, 99 dollars at moment so not to bad

I have also uploaded it to Wayne see what he comes up with, hopefully it will be much cheaper then Stellar but lets see what he says

Thanks for everyone help

Adam
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
I'm betting it won't be cheaper, but if your data is at all important then you can't go wrong with Wayne's solution.

Whatever you do, make sure you do it on a BACKUP of the file. Recovery attempts that are not successful often leave the file in worse shape than before, and can cause issues with moving forward with other recovery methods.
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
I agree with what Scott said ... make a few backups ... which should be done on a frequent basis.
In Windows Explorer ...
Highlight the db, Control C, Control V ... instant backup - 2 seconds.

mx
0
 
cdsausAuthor Commented:
So do you think i should try the Stellar Product first

It is almost the same price Wayne a little more expensive but nothing much

I suppose the one thing about Stellar is a get a tool that i can use for first attempts next time then more onto Wayne

Whats your opinion

Adam

P.S> The Stellar Trail said it can repair and i can see data
0
 
Wilder1626Commented:
It is really up to you. If you buy Stellar and it really repair the file, then it will be a good move and you will be able to use it again if needed.

But if at the end, it did not work, you may have to go with Wayne's solution. That means you will pay for only one file repair only.

But like Scott McDaniel (Microsoft Access MVP - EE MVE ) said, before you do anything, make sure to backup your Access file before you repair.
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
"Says" it can (trial) and 'Will' are two different things.

What exactly did Wayne say ?
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
IMO, you'd be much better off with Wayne handling this, rather than an automated solution. My experience with automated solutions has been spotty, at best (although I've never had any interaction with Stellar). While they claim they can recover everything, in many cases you'll find gaps and holes where data is missing.

Again, it's your data and your money, but I'd much rather have a professional handling it rather than an automated solution.
0
 
cdsausAuthor Commented:
This is still getting resolved and awaiting an answer from Wayne to see if its worth exploring via him

Adam
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Thx for update.

mx
0
 
cdsausAuthor Commented:
I haven't heard back from Wayne on the last email i put in so might just close this, thanks for all your help

Adam
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Let me  ping Wayne ....
0
 
wayne_phillipsCommented:
Thanks Joe.

Hi Adam... apologies for not getting back to your last enquiry.  I have today replied - please check your emails and your SPAM folder if you haven't received it yet.
0
 
cdsausAuthor Commented:
Thanks Wayne, what was the email address i should be looking for

Adam
0
 
wayne_phillipsCommented:
Adam, it's from support@ then my website domain (I won't put it here as I think that's against the EE rules) sent at 8:43 GMT yesterday, and resent just now from another address.
0
 
cdsausAuthor Commented:
Thanks to everyone for this didnt get it back but i certainly have a few options for next time

Thanks Wayne for your help as well

Adam
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 6
  • 5
  • 3
  • +3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now