Solved

Advise on Best Free or Paid MS Access Database Repair Tool

Posted on 2015-02-12
19
271 Views
Last Modified: 2015-04-22
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
Comment
Question by:cdsaus
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 5
  • 3
  • +3
19 Comments
 
LVL 11

Assisted Solution

by:Wilder1626
Wilder1626 earned 111 total points
ID: 40607107
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
 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 111 total points
ID: 40607245
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
 
LVL 85

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 166 total points
ID: 40607606
Agree with Joe: everythingaccess.com is the best out there for these sorts of things.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 38

Assisted Solution

by:PatHartman
PatHartman earned 56 total points
ID: 40608547
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
 

Author Comment

by:cdsaus
ID: 40608908
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
 
LVL 85

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 166 total points
ID: 40609708
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
 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 111 total points
ID: 40609973
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
 

Author Comment

by:cdsaus
ID: 40610262
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
 
LVL 11

Assisted Solution

by:Wilder1626
Wilder1626 earned 111 total points
ID: 40610268
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
 
LVL 75
ID: 40610283
"Says" it can (trial) and 'Will' are two different things.

What exactly did Wayne say ?
0
 
LVL 85

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 166 total points
ID: 40610655
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
 

Author Comment

by:cdsaus
ID: 40646210
This is still getting resolved and awaiting an answer from Wayne to see if its worth exploring via him

Adam
0
 
LVL 75
ID: 40646221
Thx for update.

mx
0
 

Author Comment

by:cdsaus
ID: 40686359
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
 
LVL 75
ID: 40686389
Let me  ping Wayne ....
0
 
LVL 1

Expert Comment

by:wayne_phillips
ID: 40686604
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
 

Author Comment

by:cdsaus
ID: 40688717
Thanks Wayne, what was the email address i should be looking for

Adam
0
 
LVL 1

Accepted Solution

by:
wayne_phillips earned 56 total points
ID: 40688997
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
 

Author Closing Comment

by:cdsaus
ID: 40739536
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently, Microsoft released a best-practice guide for securing Active Directory. It's a whopping 300+ pages long. Those of us tasked with securing our company’s databases and systems would, ideally, have time to devote to learning the ins and outs…
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

695 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question