Results 1 to 4 of 4
  1. #1
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Corrupt database (97)

    I have had a desperate colleague approach me saying that his Access database is corrupt.

    I have taken a copy of it in the hope that I could do something for him. It appears that ( against my advice) he has been embedding gif/jpeg images onto the forms to such an extent that the database is now 4Gb in size....yep you read it right 4Gb.

    I had the cunning plan of trying to import the tables into a clean database but it refuses to allow me to do it. When I try to open it, it tells me it needs to be repaired or isn't a database file, would I like to repair it, it does not allow me.

    Anybody got any ideas on how I can retrieve the data?

    Jerry
    Jerry

  2. #2
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Corrupt database (97)

    Jez

    If I'm right, Hans has mentioned this many a time.

    Search for a utility called JetComp.exe, This utility goes far beyond what Access's capabilities for repair.
    Other than that, if it's possible, import table by table indivually.

  3. #3
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Corrupt database (97)

    Thanks Dave

    I'l try the JetComp option. I have tried the table by table, with no luck and have even tried to import it into Excel, both with no joy.

    Thanks for your help

    Jerry
    Jerry

  4. #4
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Corrupt database (97)

    See Post <post#=386069>post 386069</post#> for a link to the jetcomp utility. It works great for unlocking databases.
    Regards,

    Gary
    (It's been a while!)

Posting Permissions

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