Recover deleted records from Access database?

[cj92713696]

My table looks like this:
PriKey as autonumber
Str1 as string
DateOfEntry as datetime

Before I save data from my app., I delete all entries by date and subsequently add records as new. I don't just modify my entries by doing a search, I delete, then add new always. Can I recover data that was deleted?

Thanks,
CJ

 

[SteveR77]

CJ,

The only way would be if you had set up the deletion of the records to be written to another table that was in your current database or to recover the data from a backup copy of the database.

Steve

 

[dhookom]

Depending on how important the information is, you might be able to use PK Solutions

http://www.pksolutions.com/.

Make sure you don't compact your database or the records will be un-recoverable.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.