TechRepublic|Forums|Networks

Networks

General discussion

  • Creator
    Topic
  • June 19, 2000 at 5:27 am #2073918

    Recover deleted ACCESS records

    Locked

    by jsorensen · about 21 years, 11 months ago

    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?

    Topic is locked This conversation is currently closed to new comments.
  • Creator
    Topic

All Comments

  • Author
    Replies
    • June 21, 2000 at 7:24 am #3782877

      Recover deleted ACCESS records

      by rraheb · about 21 years, 11 months ago

      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.

    • June 29, 2000 at 6:58 am #3768653

      Recover deleted ACCESS records

      by fofa · about 21 years, 11 months ago

      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.

    • July 6, 2000 at 2:58 am #3765909

      Recover deleted ACCESS records

      by mark.tassin · about 21 years, 10 months ago

      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

    • September 20, 2000 at 7:04 pm #3754814

      Recover deleted ACCESS records

      by jsorensen · about 21 years, 8 months ago

      In reply to Recover deleted ACCESS records

      This question was auto closed due to inactivity

  • Author
    Replies
Viewing 3 reply threads