Robert
robert at servicexp.com
Thu Aug 20 16:07:53 CDT 2009
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 > > ________________________________________________ > Message sent using UebiMiau 2.7.2 > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- Paul Hartland paul.hartland at googlemail.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com ________________________________________________ Message sent using UebiMiau 2.7.2 -- 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