Utilities to recover tbl removed from
TABLE tab of database window with
the DELETE key?
TABLE tab of database window with
the DELETE key?
-
-
Re: RECOVER inadvertently deleted table from mdb?
Press Ctrl-Z while in the table tab to undo.
Chris
Microsoft MVP
MLH wrote:-->Utilities to recover tbl removed from
>TABLE tab of database window with
>the DELETE key?
Message posted via http://www.accessmonster.com
-
Re: RECOVER inadvertently deleted table from mdb?
If undo doesn't work and you havn't closed the file, follow Microsoft's
instructions.
Access 2000, Access 2002, or Access 2003:
Access 95 or Access 97:
Chris
Microsoft MVP
Chris O'C wrote:-->Press Ctrl-Z while in the table tab to undo.
>
>Chris
>Microsoft MVP
>>>Utilities to recover tbl removed from
>>TABLE tab of database window with
>>the DELETE key?
Message posted via AccessMonster.c om
Comment
-
Re: RECOVER inadvertently deleted table from mdb?
On Tue, 27 May 2008 21:45:54 GMT, "Chris O'C via AccessMonster.c om"
<u29189@uwewrot e:
Yeah, good if, when you delete the table, you say "oops"
and press the key combo immediately.
>Press Ctrl-Z while in the table tab to undo.
>
>Chris
>Microsoft MVP
>
>
>MLH wrote:>>Utilities to recover tbl removed from
>>TABLE tab of database window with
>>the DELETE key?Comment
-
Re: RECOVER inadvertently deleted table from mdb?
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.
xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxx
On Tue, 27 May 2008 21:55:04 GMT, "Chris O'C via AccessMonster.c om"
<u29189@uwewrot e:
>If undo doesn't work and you havn't closed the file, follow Microsoft's
>instructions .
>
>Access 2000, Access 2002, or Access 2003:
>http://support.microsoft.com/default...;EN-US;Q209874
>
>Access 95 or Access 97:
>http://support.microsoft.com/default...;EN-US;Q179161
>
>Chris
>Microsoft MVP
>
>
>Chris O'C wrote:>>Press Ctrl-Z while in the table tab to undo.
>>
>>Chris
>>Microsoft MVP
>>>>>Utilities to recover tbl removed from
>>>TABLE tab of database window with
>>>the DELETE key?Comment
-
Re: RECOVER inadvertently deleted table from mdb?
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
MLH wrote:-->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.
>
>xxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxx
>>[quoted text clipped - 16 lines]>>If undo doesn't work and you havn't closed the file, follow Microsoft's
>>instruction s.>>>>TABLE tab of database window with
>>>>the DELETE key?
Message posted via AccessMonster.c om
Comment
-
Re: RECOVER inadvertently deleted table from mdb?
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.
xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxx
On Wed, 28 May 2008 15:14:22 GMT, "Chris O'C via AccessMonster.c om"
<u29189@uwewrot e:
>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
>
>
>MLH wrote:>>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.
>>
>>xxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxx
>>>>[quoted text clipped - 16 lines]>>>If undo doesn't work and you havn't closed the file, follow Microsoft's
>>>instructions .>>>>>TABLE tab of database window with
>>>>>the DELETE key?Comment
Comment