Undo Action Query

  • Thread starter Thread starter 123
  • Start date Start date
1

123

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
 
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
Click to expand...

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.
 
Back
Top