Discussion Locked

Recover deleted ACCESS records

0 helpful
7 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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?

7 replies

by rraheb

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.

by fofa

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.

by mark.tassin

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

This discussion is closed to new replies.