General discussion

  • Creator
    Topic
  • #2073918

    Recover deleted ACCESS records

    Locked

    by jsorensen ·

    How can I “Undelete” Records in a MS ACCESS DB that have been deleted. I know that they are “FLAGGED” for deletion until you compress the DB to reclaim the space. Does anyone know of a tool to reset these flags?

All Comments

  • Author
    Replies
    • #3782877

      Recover deleted ACCESS records

      by rraheb ·

      In reply to Recover deleted ACCESS records

      I’m not sure if this will work, try to export the data in the table to a FoxPro database file and then open that file and check if the records are there or not.

      Rafik El-Raheb.

    • #3768653

      Recover deleted ACCESS records

      by fofa ·

      In reply to Recover deleted ACCESS records

      One problem could be Access will reuse the space of the deleted records, so if there has been activity, the deleted rows could be overwritten.

    • #3765909

      Recover deleted ACCESS records

      by mark.tassin ·

      In reply to Recover deleted ACCESS records

      Important considerations when using a query that deletes records
      Once you delete records using a delete query, you can’t undo the operation. Therefore, you should preview the data that the query selected for deletion before you run the query. You can do this by clicking View on the toolbar, and viewing the query in Datasheet view.
      ? You should maintain backup copies of your data at all times. If you delete the wrong records, you can retrieve them from your backup copies.

      ? In some cases, running a delete query might delete records in related tables, even if they’re not included in the query. This can happen when your query contains only the table that’s on the “one” side of a one-to-many relationship, and you’ve enabled cascading deletes for that relationship. When you delete records from the “one” table, you’ll also delete records from the “many” table. For more information on cascading deletes, click .

      ? If you start a delete query on a Paradox, dBASE, or FoxPro table that’s linked to your d

    • #3754814

      Recover deleted ACCESS records

      by jsorensen ·

      In reply to Recover deleted ACCESS records

      This question was auto closed due to inactivity

Viewing 3 reply threads