Can Access record be "undeleted"?

[ermingut]

My program has a bug. It deletes a record, when user presses a combination of buttons.

So, very important recors is gone.

Can it be retrieved?!?

I didn't compact my database.

Please help!

[paulw]

The good news is that the record is still there. Deletion in Access merely marks the record for deletion. So make a copy of the database so that if it does get compacted you have a backup.

the bad news is that I do not know how to get it back. I will chase this, but don't despair!

Cheers,

P.

[ermingut]

Thanks.

I open Access database in text viewer. And I found record(s) - (You may say characters) that was deleted.

Simple Copy, Paste solve my problem.

[paulw]

Good, I'll stop looking. I was checking in the System Tables for a flag...

Shows how secure Access is tho'!!!

Cheers,

P.