Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2004
    Posts
    5

    Unanswered: [Help]How to recover from deleting records?

    Hey all,

    Some records are deleted by mistake from table . Could I know how to recover it? (The database has been closed after the mistake)

    Thanks!!!

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    i've subscribed to your post out of curiosity...
    ...but i think you are stuffed.

    also out of curiosity i tried a dummy db, deleting a record, and attacking it with a hex editor... the text that was in the deleted record is NOT found in the .MDB

    sorry if that is not the news you wanted to hear!

    izy
    currently using SS 2008R2

  3. #3
    Join Date
    May 2004
    Posts
    159
    BACKUPS!
    The only way out of that kind of delemma is a data backup program.

  4. #4
    Join Date
    Dec 2003
    Location
    Dallas, TX
    Posts
    1,004
    True so true,
    Once you DELETE...that's it. No coming back from the dead. As suggested, please keep frequent backups of your data. IF by chance it wasn't you who deleted the records, try designing your database with some safeguards for the future. Prevent direct access to the Tables. On your forms set them to Deletions (NO). Possibly create a custom menu that doesn't even have the Delete menu item on the toolbar. Just a few thoughts to save you headaches in the future. And then BACK UP all data, and keep a spare backup of your Database also in case someone chances it by accident. Try to have a great day.

    Bud

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •