I deleted a table by mistake

[Guest]

I deleted an important table within my database, is there any way I can get
it back? Does it go to an underlying area where I can revive it?

 

[Rick B]

Nope. You will have to restore from a backup.

 

[Jeff Conrad]

in message:

I deleted an important table within my database, is there any way I can get
it back? Does it go to an underlying area where I can revive it?

Database Design 101: Always keep good backups!

You might give this article a try:

http://support.microsoft.com/?id=209874

Good luck,

 

[Guest]

OK Jeff, thanks for that! I went to the site that explains what to type,
however, I am not that great in deciphering the codes. I can open up the
module area, but my confusion is where to type in my table name. My table
was named Activity Log In. does that get typed in between the ( ) areas?

 

[Jeff Conrad]

You need to copy/paste all of the code in the article to a new module.
Do not change any of that code.
Then compile the code (Debug | Compile).
Now open the Immedaite Window (CTRL & G)
Type this into that window:

Undo

....then hit Enter. That's it, nothing else.

*If* everything goes as planned and Access has not completley deleted
the table, then you will get a message box pop up that says a table was
recovered and lets you know what it named the table. You can then
rename it back to what it is supposed to be. You would also need to
recreate any relationships if required.

Keep your fingers crossed and give it a try.

--
Jeff Conrad
Access Junkie
Bend, Oregon

in message: