I deleted, now I'm depressed.

[Laura]

In a late night stupor, I deleted records in a Query
which deleted the same records on the originating table.
It is way too late to undo. Is this data lost forever or
could an expert find it somewhere in the depths of the
hard drive?

 

[tom mitchell]

Laura,

I feel for you as I am often afraid of doing the same thing.
Unfortunately, I don't have a solution to your problem.
Perhaps someone experienced could also tell us how to avoid this in
future. Is there any read-only function that can be applied to avoid
this sort of disaster?

Hope you can get your data back

Tom

In a late night stupor, I deleted records in a Query
which deleted the same records on the originating table.
It is way too late to undo. Is this data lost forever or
could an expert find it somewhere in the depths of the
hard drive?

Kind Regards
Tom

Please post to this newsgroup

 

[John Mishefske]

Laura,

I feel for you as I am often afraid of doing the same thing.
Unfortunately, I don't have a solution to your problem.
Perhaps someone experienced could also tell us how to avoid this in
future. Is there any read-only function that can be applied to avoid
this sort of disaster?

Hope you can get your data back

I know if you compact they will be gone permanently. Do you have a backup that
you can recover them from? How important are the records? There are services
that may be able to recover the records but they cost $$.

 

[John Vinson]

In a late night stupor, I deleted records in a Query
which deleted the same records on the originating table.
It is way too late to undo. Is this data lost forever or
could an expert find it somewhere in the depths of the
hard drive?

Talk to Peter Miller at http://www.pksolutions.com. Bring your credit
card - it's not free, but he gives good value and you only pay if he
succeeds.

 

[Albert D. Kallal]

You can implement security, and thus take away update abilities.

Of course, users should NEVER be editing the data directly anyway. If you
give the users a form, then you can simply remove the allow deletes in the
form. In fact, you can turn off the allow edits.

So, you can either set-up user security, and take away edit rights for those
tables that you don't want users to be able to change . The other way is to
simply make users have to edit the data with a form (that has the allow
edits feature set to no).

Either way will simply solve your problem.

However, there is no reason to allow users to edit the data directly. Take
read of the follwing:

http://www.mvps.org/access/tencommandments.htm