Access 97 records deleted in error

[tsmith]

How can I undelete my records? Is there a way? Thanks.

 

[John Vinson]

How can I undelete my records? Is there a way? Thanks.

Not at all easily. If you've done NOTHING since deleting the records
you can try Ctrl-Z to undo the deletion - but if you've closed the
form, the table, or the database they're gone.

There are third-party database salvage services which can recover
deleted data; the most recommended is Peter Miller at
http://www.pksolutions.com.

And... KEEP BACKUPS! A database without a backup could get corrupted
next time you open it, and you would lose *everything* in it.

 

[Tony Toews]

There are third-party database salvage services which can recover
deleted data; the most recommended is Peter Miller at
http://www.pksolutions.com.

Not even him.

Even Peter Miller, who recovers corrupted MDB files, states this can't
be done. So I'd look at retrieving those records from a backup.

Delete Records or Deleted Tables from Microsoft Access MDBs
http://www.granite.ab.ca/access/deletedata.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[John Vinson]

Even Peter Miller, who recovers corrupted MDB files, states this can't
be done. So I'd look at retrieving those records from a backup.

Thanks, Tony! I've been lucky (and careful) enough never to need to
try to do this; I'll remember in future posts (and keep my backups
even more carefully).