General discussion

Locked

Recover deleted ACCESS records

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?

This conversation is currently closed to new comments.

7 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Recover deleted ACCESS records

by rraheb In reply to Recover deleted ACCESS re ...

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.

Collapse -

Recover deleted ACCESS records

by jsorensen In reply to Recover deleted ACCESS re ...

The question was auto-closed by TechRepublic

Collapse -

Recover deleted ACCESS records

by fofa In reply to Recover deleted ACCESS re ...

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.

Collapse -

Recover deleted ACCESS records

by jsorensen In reply to Recover deleted ACCESS re ...

The question was auto-closed by TechRepublic

Collapse -

Recover deleted ACCESS records

by mark.tassin In reply to Recover deleted ACCESS re ...

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

Collapse -

Recover deleted ACCESS records

by jsorensen In reply to Recover deleted ACCESS re ...

The question was auto-closed by TechRepublic

Collapse -

Recover deleted ACCESS records

by jsorensen In reply to Recover deleted ACCESS re ...

This question was auto closed due to inactivity

Back to Networks Forum
7 total posts (Page 1 of 1)  

Related Discussions

Related Forums