Retrieving Lost records

S

sighawk49

Is it possible to retrieve a set of records from an Access table that have
been cut from the table after another cut and paste have been performed?
 
6

'69 Camaro

Sorry. When you "cut" records, they are marked for deletion within the
table and saved to the Windows clipboard until you replace the Windows
clipboard with something else. If you don't use those records for a paste
operation before the Windows clipboard is overwritten, then those records
are not recoverable.

Because of the way Jet handles the space for records marked for deletion
(the bytes from the each of these "deleted" records are partially
overwritten with other values), even disaster recovery specialists (like the
company I work for) can recover only "up to five percent" of the data in the
records.

You'll have to rely on your latest backup to replace those records.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Any human can read my reply E-mail address and should alter it so that a
message will be forwarded to me. Spammers are free to use my UNALTERED
reply E-mail address. I will *never* get those messages!)
 
6

'69 Camaro

I don't want to get your hopes up. The chances are really slim that you
could retrieve this data from the Windows clipboard.

The "clipboard" is actually RAM. There is no guarantee that the data that
was saved to the clipboard is in contiguous RAM, so even if you used the
Windows API's to read that memory, you'd have to "dump" all of it. And this
would have to be pretty immediate, because the OS is continually moving
things in and out of RAM while it does OS housekeeping, even if the user
isn't doing any further computer operations. Windows also uses "temp" files
to temporarily hold some of this information while it swaps data in and out
of memory, so copying those "temp" files to a more permanent storage place
would also need to be done immediately, too, in case some of that clipboard
data was actually saved in a temp file. And there's no guarantee that data
in these temp files could be identified as "clipboard" data.

Your questions would probably be better answered in a Windows forum, where
the Windows whizzes hang out. Good luck.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Any human can read my reply E-mail address and should alter it so that a
message will be forwarded to me. Spammers are free to use my UNALTERED
reply E-mail address. I will *never* get those messages!)
 
Top