[AccessD] Hosed back end

Rocky,

Yes, I would try JetComp as suggested by Rusty.

If that doesn't do the trick, I can recommend the service provided by Wayne 
Phillips at http://www.everythingaccess.com/accessdatabaserepair.htm

Regards
Steve


--------------------------------------------------
From: "Rocky Smolin" <rockysmolin at bchacc.com>
Sent: Tuesday, December 15, 2009 6:12 AM
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Subject: [AccessD] Hosed back end

> Dear List:
>
> Client has a back end which I think was corrupted by a remote user 
> dropping
> out at an inopportune moment.  But when I try to open this database I get
> the message that the database is corrupted would I like Access to try to 
> fix
> it. I say Yes and the hourglass shows but nothing happens - I don't even 
> see
> the db1.mdb which gets created during a compact - don't know if that is
> supposed to happen in a repair.
>
> Anyway, after 5 minutes I terminate it as I don't think it's going to
> complete successfully. Decompile doesn't work - I get the same dialog box
> asking if I want Access to repair it. The mdb is only 27MB so I don't 
> think
> it should take more than a couple minutes to repair.  I could put it on a
> second machine and let it run for an hour - see if anything happens. 
> Could
> it take more than a few minutes to repair a 27MB mdb?
>
> I tried importing the tables into a clean mdb but I can't open the hosed
> database to see the tables.
>
> They can restore from Wednesday's backup so they're not dead in the water.
> But is there any other alternative to repairing or recovering the data 
> from
> this mdb?