[AccessD] Corrupted mde

You say you can *see* the BE tables via the FE links. Can you see the data? If so then just build a bunch of MakeTable queries to dump the contents into a new BE - MDB (why would they want an MDE back end?).

e.g. SELECT SomeTable.* INTO SomeTable IN '\\Server\Share\Folder\NewBE.MDB' FROM SomeTable;

Lambert

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Thursday, April 11, 2013 3:22 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Corrupted mde

Sorry for the double post but I didn't see this come through the first time.
 
R

  _____  

From: Rocky Smolin [mailto:rockysmolin at bchacc.com] 
Sent: Thursday, April 11, 2013 11:01 AM
To: 'Access Developers discussion and problem solving'
Subject: Corrupted mde


Dear List:
 
I have a client who has a commercial application which is FE/BE, but the BE
is an mde.
 
One of his users has a large BE which has become corrupted.  Cannot see the
tables in the BE of course, but can see them through the FE links.
 
Compact and repair from the FE fails.  Decompile won't work .
 
Any suggestions on how to most quickly recover the data in the corrupted BE.
 
MTIA
 
Rocky Smolin
Beach Access Software
858-259-4334
www.bchacc.com <http://www.bchacc.com/> 
www.e-z-mrp.com <http://www.e-z-mrp.com/> 
Skype: rocky.smolin