[AccessD] Hosed back end

Rocky, 
Microsoft has a utility called JetComp that may help.  It can be found
here:

http://support.microsoft.com/kb/295334


HTH

Rusty
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Monday, December 14, 2009 11:13 AM
To: 'Access Developers discussion and problem solving'
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?

MTIA

Rocky Smolin

Beach Access Software

858-259-4334

www.e-z-mrp.com <http://www.e-z-mrp.com/> 

www.bchacc.com <http://www.bchacc.com/> 

 

 

**********************************************************************
WARNING: All e-mail sent to and from this address will be received,
scanned or otherwise recorded by the CPI Qualified Plan Consultants, Inc.
corporate e-mail system and is subject to archival, monitoring or review 
by, and/or disclosure to, someone other than the recipient.
**********************************************************************