Results 1 to 6 of 6
  1. #1
    3 Star Lounger
    Join Date
    Sep 2002
    Location
    London, England
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Restore Corrupt Database (2002)

    Does anybody have any experience/advice/recomendations regarding commercially available products that restore corrupt Access databases? I have tracked down two, AccessFix and AccessRecovery. AccessFix is

  2. #2
    3 Star Lounger
    Join Date
    Sep 2002
    Location
    London, England
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Restore Corrupt Database (2002)

    Finally worked out how to download the AccessRecovery demo. It also seems to work. It allows you to save but only leaves real data in some of the records. There was there to confirm that the primary keys and autonumbers are intact.. So far it looks the better bet.

    Ian

  3. #3
    4 Star Lounger
    Join Date
    Sep 2004
    Location
    Sacramento, California, USA
    Posts
    432
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Restore Corrupt Database (2002)

    (Edited by HansV to make URL and reference to post clickable - see <!help=19>Help 19<!/help>)

    Have you tried using jetcomp? It is a free product. I saw it recommended in the lounge and I used it on a corrupt database a few months ago and was able to recover it.
    See <post#=404706>post 404706</post#> or

    Recommend see MSKB 273956:

    http://support.microsoft.com/default.aspx?...amp;Product=acc

    Carla

  4. #4
    3 Star Lounger
    Join Date
    Sep 2002
    Location
    London, England
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Restore Corrupt Database (2002)

    Yes, the first thing I do with a corrupt database is go through a sort of check list:

    1) Compact and Repair
    2) JetComp (in this instance the one for 2002 that you get from KB article 295334)
    3) Try importing the objects into another database
    4) Talk to the users about backup
    5) Dispair, and dust off my SQL Server training notes

    Most of the time Compact and Repair works. When it doesn't the chances of the others working are, in my experience, slim. Occasionally they do, and that has been a lifesaver, but mostly they don't.
    I now have a desperate user and the demos of two products, both of which seem to have succeeded where the standard and free alternatives have not. I'm going to bite the bullet and buy the full version of AccessRecovery. I live in the UK and with the US dollar being so low at the moment it only costs me a few more quid anyway. I'll post my results.

    The dollar really is low at the moment. I wonder if there's any other software I should be looking into?

    Ian

  5. #5
    3 Star Lounger
    Join Date
    Sep 2002
    Location
    London, England
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Restore Corrupt Database (2002)

    Very disappointing so far. I paid the money and was sent an email with a link to follow for immediate dowload. This link , the email informs me, is only avaiable to me for seven days.
    On following the link I get a page with this message:

    We're Sorry!
    The page that you have requested can not be found or has been moved.
    We suggest that you use the navigation links found on this page to ensure that you find what you are looking for.

    This page is on another company's site and does not contain any information about AccessRecovery at all.
    I have emailed the support addresses, but I am now despondent.
    I have spent a lot of money
    I have no software
    The web site(s) involved are no help at all
    There's no advice in the demo product (the help section on upgrading to the full version is just a glorified link to the buying section of the web site - been there!)
    The support personnel will probably not even be able to help until the US wakes up, which is half a day after my clients wake up in the UK
    The promised 5% discount for respnding in 24 hrs was not deducted
    Oh, did I mention that my clients still don't have any data.

    Very poor service and yet another selling web site that offers next to no help when things go wrong.
    Every time I read their seven day deadline in their email I feel a bit more warmly disposed to the NRA.

    Ian

  6. #6
    3 Star Lounger
    Join Date
    Sep 2002
    Location
    London, England
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Restore Corrupt Database (2002)

    A corrected version of the installation email has been sent, the link in it worked and the database has been recovered, as far as I can tell. I'm not sure I would recommend their web site/designers to anybody but the product itself appears to work (very quickly and simply) and they may well have had someone working on Sunday, it's hard to tell. All in all, I'm happy again, although I wasted a lot of my weekend unnecessarily.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •