Re: [mdb-dev] undelete a deleted record from a mdb?

[klemens z. <zw...@vo...>]

hi,
       =20
        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.
       =20
        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... :)
>=20
> FWIW Peter Miller is well known for being able to recover deleted
> MDBs.
>=20
> 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?
>=20
> 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.
>=20
> 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.
>=20
> -----
> Tony Toews, Microsoft Access MVP
> Microsoft Access Links, Hints, Tips & Accounting Systems at
>    http://www.granite.ab.ca/accsmstr.htm
--=20
klemens zwischenbrugger <zw...@vo...>