Undeleting rows

J

Jeff Boyce

Peter

If you mean actually deleting a row, I'm not aware of a way to do that.

If, perchance, you are referring to one/more tables that have been deleted,
there's a KB article (209874) that outlines how you can recover a deleted
table under the following conditions:
. The database has not been closed since the tables were deleted.
. The database has not been compacted since the tables were deleted.
. The tables were deleted using the Microsoft Access user interface.
 
M

Mike Labosh

Is it possible in MS Access undelete deleted rows ?

No, but your backup / restore software can :)

This is why, by default, Access prompts you with an "Are you sure?" message
when you delete something.

But that's only with the GUI.

If you're using DAO / ADODB and you've got a Recordset -- if you say
"rs.Delete" in your code, there is no prompt. It's just gone. So if you
have such a feature coded in your application, you have to provide your user
with with your own mechanism for prompting them

This behavior can be especially dangerous if you're using Cascading Deletes
on your relationships. Deleting a "Customer" could also delete related
"Orders", "Order Details", etc.

--
Peace & happy computing,

Mike Labosh, MCSD

"When you kill a man, you're a murderer.
Kill many, and you're a conqueror.
Kill them all and you're a god." -- Dave Mustane
 
Top