P
Peter Trojak
Is it possible in MS Access undelete deleted rows ?
thanks
thanks
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.
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
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
J
Joseph Meehan
Peter said:
In Access they are records. Spreadsheets have rows. I only point this
out because it is a critical difference in the two. Rows do not act like
records.
The answer to your question is yes and no.
Yes it can be done.
No you are not likely to be able to do it yourself, it generally takes
special skills and tools not available to most of us.
Yes, it cost money and will likely cost more than it is worth.
When you do a compact of the database then all deleted records forms
reports etc, are really deleted. Until then they are just marked deleted,
but Access does not have the tools built in to view them or change their
status.