[AccessD] Hosed back end

Rusty:

Thanks - but wouldn't compact.  Got an error reading the source.

Rocky
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rusty Hammond
Sent: Monday, December 14, 2009 9:36 AM
To: Access Developers discussion and problem solving
Subject: Re: [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.
**********************************************************************

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com