Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Repair DB (2002 sp3)

    I have a database that needs repaired but the normal compact and repair utility crashes about halfway through the repair. I tried to create a new db and do an import but Access still says the original needs to be repaired first. Are there any other repair utilities available. As always, TIA.

  2. #2
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Repair DB (2002 sp3)

    Check out JetComp.exe or Corruption at

    http://home.bendbroadband.com/conradsystem.../resources.html

    HTH

    John

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Repair DB (2002 sp3)

    See Jet compact utility is available in download center. This free utility from Microsoft tries to compact and repair the database without opening it, so it can repair some databases that the built-in command can't handle.

    If this doesn't work, you can try importing data from the tables into Excel: select Data | Import External Data | New Database Query, using the ODBC driver for Access. You'll only be able to salvage data this way (at most), no forms, reports etc.

    There are many commercial repair services for Access databases (search Google), but I have no idea how good they are.

  4. #4
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Repair DB (2002 sp3)

    John and Hans: Thanks for the suggestions. I will look into all.

Posting Permissions

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