Networks

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.

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.

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 question was auto closed due to inactivity