Andy Lacey
andy at minstersystems.co.uk
Fri Sep 18 03:19:20 CDT 2009
Hi folks Just some feedback on this thread from a while back. I downloaded the trial version of the AccessFix product which Gary suggested. When I ran the product against my db it found 1700+ deleted records. What the trial version does is display the records in your browser, scrollable so you can see the results. You then have to pay for the full product to recover that data to a db. We never did pay for the full version because I could see that the data was incomplete. There were 0's in the Autonumber key in some records and a Hyperlink field which was crucial to the app was very poorly recovered if at all. I emailed the vendors about these issues but got no response. So we didn't buy the product but even the info on-screen enabled me to tell the user what records had been added or amended since the last backup they had, for which info they were very grateful. So I learned that: - deleted records are still there (presumably until a Compact) - it's possible to recover information about deleted records in some shape or form - AccessFix proved a useful tool even in the free trial form but was not a 100% solution We never did try the recovery service which Jim suggested (I was told not to) but I've seen enough to suggest that it's feasible, and in fact Jim said it had worked for him. So if it happens to you or your user don't dismiss the idea of recovering the data. Andy -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Robert Sent: 20 August 2009 22:08 To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Recover deleted records Yea maybe.. but I was focused on the "deletions in Access are immediate and permanent." Comment ;-) WBR Robert -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman Sent: Thursday, August 20, 2009 9:23 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Recover deleted records Your not interpreting that quite right. All he is saying is that through he DBMS, you cannot go in and un-delete a record like you can with dBase. Records are still on the pages until the page is re-written. Of course you'd get a lot of other junk as well because if you read the page to recover it, you're going to get everything deleted prior to this as well. A recovery service is worth a shot... Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Robert Sent: Thursday, August 20, 2009 7:28 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Recover deleted records Andy, I think you may be in a bit of trouble... Take a look at.... http://allenbrowne.com/xbase-06.html WBR Robert -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andy Lacey Sent: Thursday, August 20, 2009 7:43 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Recover deleted records Hi Paul Yes I ahve and I just get the 13. I don't think there's any mystery. I think the records have been cleanly deleted somehow. But as the MDB's not been compacted they're in there and I wondered if they could be undeleted. Or am I slipping into old dBase/Clipper speak? -- Andy Lacey http://www.minstersystems.co.uk --------- Original Message -------- From: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Subject: Re: [AccessD] Recover deleted records Date: 20/08/09 10:33 Andy, I'm in the uk but not seen this before, apart from when a filter was applied to the table then saved. I assume you have tried creating a new MDB and importing the table into that to see what you get ? Paul 2009/8/20 Andy Lacey <andy at minstersystems.co.uk> > Hi folks > Anyone have good experience of either a service (preferably in UK) or > software that will restore deleted records in an MDB? The MDB's not corrupt > in any way but there are only 13 records in a table where there should be > hundreds if not thousands. The MDB has not been compacted, and size is > still > huge, so I expect those babies are in there. But how do we get them back? > > And pleeease don't reply backup tape. Yes that's the first resort we're > looking at but the db hasn't been used for weeks so the oldest backup may > not be any better. I'm looking at alternatives. > > -- > Andy Lacey > http://www.minstersystems.co.uk > > ________________________________________________ >