Rocky Smolin
rockysmolin at bchacc.com
Tue Jan 24 07:59:19 CST 2012
I think you're right about me looking at it. I don't think I have anything you haven't tried. Had a client last month whose back end got hosed. They were doing regular backups until the boss got a new machine - his box was the peer server for the back end. At that point no one restarted the daily backup procedure. So their last backup was way too old to be of any use. I put in several hours recovering their database - just lucky that I was able to. Cost him $600 - he cried but had no choice. Think I'll call him today and verify they're now doing backups. Does your client at least have a reliable way to re-create the work that was done since the last backup? Mine would have had a bitch of a time doing it. R -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark Breen Sent: Tuesday, January 24, 2012 1:32 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Help - Corrupt Access MDB File Hi Guys, Thank you all for your responses. I tried JetComp for 2000 and for 2003. Failed immediately. I tried Everythingaccess and they failed immediately. We tried another tool (not sure what is was) and it also failed. Everything Access and the other tool did manage to rescue one table, but only about 17 rows. the db contains about 100 tables and tens of thousands of records. Finally, the real disappointment for me is the zip figures, it is zipping from 219 MB to 291k, this is a 99.9% reduction. I have to assume that with statistic, it means there is nothing left. Rocky, if you like, I can ask permission to send it over, but I fear I am wasting your time. re backups: the client has a backup from last Wednesday, but not since then, so the have to re-key all the important data. It is not good but there is nothing else to do at this stage. Finally, when I was posting the message last night (at 17:00 Irish time), I told the client about AccessD and mentioned to her that the people are kind and also typically responded within a few hours. Last night I had valuable responses within 90 mins, thank you for your time. Mark On 23 January 2012 18:24, Rocky Smolin <rockysmolin at bchacc.com> wrote: > Mark: > > 90% compression would not be unusual IME. But from your description > it sounds well and truly hosed. > > How about decompile? Probably not a winner but you could try. > > Dare I ask when their last backup was? > > Possibly you'd have better luck with A2003? Or earlier? > > If you shoot it over I could give it a try here. > > Rocky > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters > Sent: Monday, January 23, 2012 10:19 AM > To: 'Access Developers discussion and problem solving' > Subject: Re: [AccessD] Help - Corrupt Access MDB File > > A pay site to get this fixed is www.everythingaccess.com. I don't > know what they charge. > > Unfortunately, if this has zipped down to 219K, there may be nothing left. > > Dan > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark Breen > Sent: Monday, January 23, 2012 11:15 AM > To: Access Developers discussion and problem solving > Subject: [AccessD] Help - Corrupt Access MDB File > > Hello AccessD, > > Since Access 1.0, I have not had a corrupt access file, but I have one > today. > > Can you advice me what I should do? it is either 2000 or 2002-2003 format. > > I cannot open, and cannot import objects and cannot compant and repair > with Access 2010. Each time Access says "un recognised database format". > > Finally, the file is 219 MB and it zipped to 219KB, which is way to tiny. > > Any suggestions appreciated, > > thanks > > Mark > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com