Solved

Advise on Best Free or Paid MS Access Database Repair Tool

Posted on 2015-02-12
19
259 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
  • 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 - Access MVP)
DatabaseMX (Joe Anderson - Access MVP) 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 84

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
 
LVL 34

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 84

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 - Access MVP)
DatabaseMX (Joe Anderson - Access MVP) 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
VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

 
LVL 75
ID: 40610283
"Says" it can (trial) and 'Will' are two different things.

What exactly did Wayne say ?
0
 
LVL 84

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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Before insert Image (OLE) resize image 11 40
Newbie needs help printing from a form. 10 18
how to link subforms ms/access VBA 6 23
MS Access 03, TransferText, decimal places 8 35
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
This article explains all about SQL Server Piecemeal Restore with examples in step by step manner.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

937 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

Need Help in Real-Time?

Connect with top rated Experts

5 Experts available now in Live!

Get 1:1 Help Now