[AccessD] Recover deleted records

Andy Lacey andy at minstersystems.co.uk
Thu Aug 20 12:39:11 CDT 2009


Not necessarily Charlotte. See other posts in the thread.

Andy

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: 20 August 2009 16:39
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Recover deleted records


You're thinking of dBase.  Records weren't truly deleted there until you
packed the database.  In Access, gone is gone.

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andy Lacey
Sent: Thursday, August 20, 2009 4: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




More information about the AccessD mailing list