[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mdbtools-dev
Subject:    Re: [mdb-dev] undelete a deleted record from a mdb?
From:       klemens zwischenbrugger <zwiskle () vol ! at>
Date:       2003-08-18 22:21:59
[Download RAW message or body]

hi,
        
        yes, i've read that too.
        my tables have some 'memo' fields, so i was hoping that
        something has survived...
        but in fact it looks not good :(
        some export stalled (took cpu for minutes without doing anything
        in output), some segfaulted. seems to be 'quite dirty' inside.
        
        So i realy start to think to move the DB-part to mysql since
        they have a update-log (
        http://www.mysql.com/doc/en/Update_log.html ) which might rescue
        in such a case.

.klemens

On Mon, 2003-08-18 at 23:54, Tony Toews wrote:
> >         I'll give another report if I success to get-back some of
> > the
> >         deleted data... :)
> 
> FWIW Peter Miller is well known for being able to recover deleted
> MDBs.
> 
> by Peter Miller of PK Solutions
> Question: A user at work has accidentally erased the contents of an
> Access MDB. The file size is still as it originally was. Is there
> *any* way of getting the data back?
> 
> Answer: No, not really. Although the space used to store the deleted
> records remains unchanged, the actual contents of that storage are not
> just deleted, but duplicated in part. Typically, only about one out of
> every twenty records is recoverable, for technical reasons. Basically,
> although the undeleting is easy enough, Access/Jet copy the first
> deleted record on a page over the remaining deleted records on hat
> page. Typically there are twenty or more records per page, and hence
> the 95%+ data loss.
> 
> That said, if the table had been deleted, rather than just its
> records, it would indeed be recoverable. In fact, if all tables had
> been deleted, they would all be recoverable. But records deleted from
> a table that is not deleted are indeed toast, or at least
> predominantly so.
> 
> -----
> Tony Toews, Microsoft Access MVP
> Microsoft Access Links, Hints, Tips & Accounting Systems at
>    http://www.granite.ab.ca/accsmstr.htm
-- 
klemens zwischenbrugger <zwiskle@vol.at>

["signature.asc" (application/pgp-signature)]
-------------------------------------------------------
This SF.Net email sponsored by: Free pre-built ASP.NET sites including
Data Reports, E-commerce, Portals, and Forums are available now.
Download today and enter to win an XBOX or Visual Studio .NET.
http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01
_______________________________________________
mdbtools-dev mailing list
mdbtools-dev@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mdbtools-dev

[prev in list] [next in list] [prev in thread] [next in thread]