Access 97 records deleted in error

message from tsmith@hpbs.org on 18 May 2004
How can I undelete my records? Is there a way? Thanks.
 
John Vinson replied to tsmith@hpbs.org on 18 May 2004
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.

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public
 
Tony Toews replied to John Vinson on 23 May 2004
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
 
John Vinson replied to Tony Toews on 23 May 2004
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).

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public
 

Archived message: Access 97 records deleted in error (MS Access Forms)