mdb repair

Discussion in 'Access Table Design' started by Jay Vinton, Jul 26, 2007.

  1. Jay Vinton

    Jay Vinton Guest

    Can anyone recommend software for repairing a 2000 mdb? There are many
    choices with a wide range of prices but none lets you look at the actual
    repaired db prior to purchace.

    My problem child opens okay and seems to be functional but apparently the
    user has never compacted it in a couple of years and what should be about
    30MB is now almost 400MB. It's just data with no forms, code, etc.

    It crashes Access, Jetcomp, and the Windows ODBC Data Source Administrator
    when I try to repair it. And it crashes Access when I try to import it into a
    new db.

    Thanks
     
    Jay Vinton, Jul 26, 2007
    #1
    1. Advertisements

  2. What happens when you try to import just one table at a time? You may be able
    to find just one table that is the problem. You could then use a make table
    query to extract most of the records.

    Check for problem memo fields. If you can do a make table excluding the memo
    fields then export the new table, there's the problem. If you can further
    define which record(s) are the problem, you can extract almost everything
    except the bad memo data for the problem records.

    Have you tried working on the database using another computer? There might
    be something wrong with your PCs Office installtion.
    --
    Jerry Whittle, Microsoft Access MVP
    Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


    "Jay Vinton" wrote:

    > Can anyone recommend software for repairing a 2000 mdb? There are many
    > choices with a wide range of prices but none lets you look at the actual
    > repaired db prior to purchace.
    >
    > My problem child opens okay and seems to be functional but apparently the
    > user has never compacted it in a couple of years and what should be about
    > 30MB is now almost 400MB. It's just data with no forms, code, etc.
    >
    > It crashes Access, Jetcomp, and the Windows ODBC Data Source Administrator
    > when I try to repair it. And it crashes Access when I try to import it into a
    > new db.
    >
    > Thanks
     
    Jerry Whittle, Jul 26, 2007
    #2
    1. Advertisements

  3. Jay Vinton

    Jay Vinton Guest

    Thanks for the good tips. This was a customer's db and after a lot of (free)
    trial & error, I found enough bad records and general weirdness that I sent
    them to a data recovery shop.

    A few hundred dollars later, they got the db back but that process lost a
    bunch of indexes & relations. We fixed that part and it seems to be okay now.
    I wish MSDE had been available when this application was born...

    Thanks again
     
    Jay Vinton, Aug 11, 2007
    #3
  4. Hi,
    Here are some Access database recovery tools that may be able to repair your mdb file. Below is a list of them:

    http://www.datanumen.com/aar/compare.htm

    Most of them provide a free demo so you can try first.

    Alan


    > On Thursday, July 26, 2007 2:30 PM JayVinto wrote:


    > Can anyone recommend software for repairing a 2000 mdb? There are many
    > choices with a wide range of prices but none lets you look at the actual
    > repaired db prior to purchace.
    >
    > My problem child opens okay and seems to be functional but apparently the
    > user has never compacted it in a couple of years and what should be about
    > 30MB is now almost 400MB. It's just data with no forms, code, etc.
    >
    > It crashes Access, Jetcomp, and the Windows ODBC Data Source Administrator
    > when I try to repair it. And it crashes Access when I try to import it into a
    > new db.
    >
    > Thanks



    >> On Thursday, July 26, 2007 2:50 PM JerryWhittl wrote:


    >> What happens when you try to import just one table at a time? You may be able
    >> to find just one table that is the problem. You could then use a make table
    >> query to extract most of the records.
    >>
    >> Check for problem memo fields. If you can do a make table excluding the memo
    >> fields then export the new table, there's the problem. If you can further
    >> define which record(s) are the problem, you can extract almost everything
    >> except the bad memo data for the problem records.
    >>
    >> Have you tried working on the database using another computer? There might
    >> be something wrong with your PCs Office installtion.
    >> --
    >> Jerry Whittle, Microsoft Access MVP
    >> Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
    >>
    >>
    >> "Jay Vinton" wrote:
     
    alanlisa chen, Nov 5, 2011
    #4
  5. Jay Vinton

    Guest

    Access database contains various records in the form of tables which are accessed by the users to retrieve information. The MDB files or the Access database files may get corrupted or damaged due to various defined or unfamiliar reasons. When such corruption occurs in Access database, recovery tool needs to be used which can be downloaded from http://www.accessrecovery.org/ to repair the MDB files and retrieve the database. One can easily use such recovery tool as these are available on net.
     
    , Jun 15, 2012
    #5
  6. Jay Vinton

    Guest

    On Friday, July 27, 2007 12:00:04 AM UTC+5:30, Jay Vinton wrote:
    > Can anyone recommend software for repairing a 2000 mdb? There are many
    > choices with a wide range of prices but none lets you look at the actual
    > repaired db prior to purchace.
    >
    > My problem child opens okay and seems to be functional but apparently the
    > user has never compacted it in a couple of years and what should be about
    > 30MB is now almost 400MB. It's just data with no forms, code, etc.
    >
    > It crashes Access, Jetcomp, and the Windows ODBC Data Source Administrator
    > when I try to repair it. And it crashes Access when I try to import it into a
    > new db.
    >
    > Thanks


    Kernel for Access database recovery which is available at http://www.accessrecoverytool.net/ is equipped with standard algorithm that ensures smooth retrieval of data from the corrupt MDB/ACCDB files. The software uses two modes of file repair i.e., Standard and template. The template recovery mode is used for data recovery from the partly damaged MDB/ACCDB files. If the recovery from the template mode is not possible, then the user can choose standard recovery option of the program to repair the damaged access databasefiles.
     
    , Jul 4, 2012
    #6
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Marty
    Replies:
    0
    Views:
    70
    Marty
    Aug 7, 2003
  2. Marty
    Replies:
    0
    Views:
    125
    Marty
    Aug 15, 2003
  3. Penny

    DB Needs Repair Messages

    Penny, Sep 16, 2003, in forum: Access Table Design
    Replies:
    1
    Views:
    82
    Lynn Trapp
    Sep 16, 2003
  4. Mike

    Problem with compact and repair database

    Mike, Dec 28, 2003, in forum: Access Table Design
    Replies:
    1
    Views:
    82
    Allen Browne
    Dec 28, 2003
  5. chris

    How to repair index corruption

    chris, Jun 17, 2004, in forum: Access Table Design
    Replies:
    9
    Views:
    122
    Jeff Boyce
    Jun 25, 2004
  6. René

    compact and repair

    René, Jun 27, 2004, in forum: Access Table Design
    Replies:
    1
    Views:
    88
    Eric Butts [MSFT]
    Jun 30, 2004
  7. Maniam
    Replies:
    0
    Views:
    65
    Maniam
    Sep 25, 2004
  8. Laurel

    Clean up a table or mdb beyond compact and repair?

    Laurel, Sep 21, 2006, in forum: Access Table Design
    Replies:
    2
    Views:
    121
    Laurel
    Sep 21, 2006
Loading...