RECOVER inadvertently deleted table from mdb?

RECOVER inadvertently deleted table from mdb?

Post by MLH » Thu, 29 May 2008 04:40:18


Utilities to recover tbl removed from
TABLE tab of database window with
the DELETE key?
 
 
 

RECOVER inadvertently deleted table from mdb?

Post by Chris O'C » Thu, 29 May 2008 06:45:54

Press Ctrl-Z while in the table tab to undo.

Chris
Microsoft MVP




--
Message posted via http://www.yqcomputer.com/

 
 
 

RECOVER inadvertently deleted table from mdb?

Post by Chris O'C » Thu, 29 May 2008 06:55:04

If undo doesn't work and you havn't closed the file, follow Microsoft's
instructions.

Access 2000, Access 2002, or Access 2003:
http://www.yqcomputer.com/ ;EN-US;Q209874

Access 95 or Access 97:
http://www.yqcomputer.com/ ;EN-US;Q179161

Chris
Microsoft MVP




--
Message posted via AccessMonster.com
http://www.yqcomputer.com/
 
 
 

RECOVER inadvertently deleted table from mdb?

Post by MLH » Thu, 29 May 2008 22:20:39

On Tue, 27 May 2008 21:45:54 GMT, "Chris O'C via AccessMonster.com"

Yeah, good if, when you delete the table, you say "oops"
and press the key combo immediately.
 
 
 

RECOVER inadvertently deleted table from mdb?

Post by MLH » Thu, 29 May 2008 22:23:55

Yeah, but if you've done ANYthing at all that writes to db, won't
work. Even creating the module, pasting the code to it and saving
it renders the table unrecoverable. I won't be without this code
snippett in my future endeavors. Repopulating the table was not
an enjoyable task. I was hoping some third party utility would
dig deeper & do a bit more. Thx 4 comments.

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx



On Tue, 27 May 2008 21:55:04 GMT, "Chris O'C via AccessMonster.com"
 
 
 

RECOVER inadvertently deleted table from mdb?

Post by Chris O'C » Fri, 30 May 2008 00:14:22

I just tested your theory, and I was able to recover my deleted table. This
is what I did: I copied a working Access 2K mdb file, and opened the copy.
I created a new test table, then deleted it. Then I deleted another table.
Then I created a new query, a new form and a new module. In the new module,
I copied the code from the Access 2K recovery method and pasted it into the
module, saved and compiled. Then I created another new table. All of these
activities wrote to the db file.

I ran the code and recovered not only the table I deleted, but the first test
table I created and deleted.

So you must have done something more than just write to the db in a new
module for the code to fail. Did you close the db prior to the recovery?
The code won't work if you close, then reopen the db.

You can find services on the Internet that will recover your deleted table,
but they're expensive. It's best to have recent backups.

Chris
Microsoft MVP




--
Message posted via AccessMonster.com
http://www.yqcomputer.com/
 
 
 

RECOVER inadvertently deleted table from mdb?

Post by MLH » Sat, 31 May 2008 21:21:24

You must be right. Proof is in the results. On my end, I had the
presence of mind (after doing the dastardly deed) to NOT close
the database. I realized instantly what I'd done. I had copied
it to a table of another name (CTRL-C ; CTRL-V) but didn't take
a moment to notice that I'd copied STRUCTURE only - no data.
As I recall, I opened browser, searched MSoft for a solution.
Found one. Copied / Pasted / Compiled / No errors / Crossed
Fingers / Tested & failed miserably.

R U running A97? Is there any autosave feature that I might
have enabled that could have screwed me?

Thx for your exhaustive test report.
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx


On Wed, 28 May 2008 15:14:22 GMT, "Chris O'C via AccessMonster.com"