By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,952 Members | 1,686 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,952 IT Pros & Developers. It's quick & easy.

RECOVER inadvertently deleted table from mdb?

P: n/a
MLH
Utilities to recover tbl removed from
TABLE tab of database window with
the DELETE key?
Jun 27 '08 #1
Share this Question
Share on Google+
6 Replies


P: n/a
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

Jun 27 '08 #2

P: n/a
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?
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200805/1

Jun 27 '08 #3

P: n/a
MLH
On Tue, 27 May 2008 21:45:54 GMT, "Chris O'C via AccessMonster.com"
<u29189@uwewrote:
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?
Jun 27 '08 #4

P: n/a
MLH
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.

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx x

On Tue, 27 May 2008 21:55:04 GMT, "Chris O'C via AccessMonster.com"
<u29189@uwewrote:
>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?
Jun 27 '08 #5

P: n/a
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.

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xx
>>If undo doesn't work and you havn't closed the file, follow Microsoft's
instructions.
[quoted text clipped - 16 lines]
>>>>TABLE tab of database window with
the DELETE key?
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200805/1

Jun 27 '08 #6

P: n/a
MLH
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.
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxx
On Wed, 28 May 2008 15:14:22 GMT, "Chris O'C via AccessMonster.com"
<u29189@uwewrote:
>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.

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxx
>>>If undo doesn't work and you havn't closed the file, follow Microsoft's
instructions.
[quoted text clipped - 16 lines]
>>>>>TABLE tab of database window with
>the DELETE key?
Jun 27 '08 #7

This discussion thread is closed

Replies have been disabled for this discussion.