123 said:
Thank you for your help and answer:
Is there any way to undo action query specialy that made by
docmd.runsql. thank you for your help and answer
You mean, after you've already replied "Yes" to the "Are you sure?"
prompt? As a rule, no. If it was a make-table query, you can of course
delete the table you made. If it was an append query, you could delete
the records you appended, if you can identify them by their contents.
If it was an update query, there is no way to undo it. If it was a
delete query, there is no way to undo it, but *if you have made no
further changes to the database since then and not compacted it*, then a
data recovery specialist such as PK Solutions (
www.pksolutions.com)
*may* be able to recover some of the data.
