HELP! Iam desperate!

[Dimitris]

I need immediate help. I accidently deleted a table and I have no back-up.
I know that there is no excuse but I learned the hard way.
Please tell me that there is a solution!!
I am desperately waiting for good news!
Thanks
Dimitris

 

[Rick B]

Do a search. This question was asked Friday, and one of the MVPs posted
some 'magic code' that could be pasted in a module and run to retrieve a
deleted table in some cases.

Do a search on posts from the last few days and you should find it.

 

[Rick B]

Here is that post I just mentioned....


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,
--
Jeff Conrad
Access Junkie
Bend, Oregon

 

[Jeff Conrad]

in message:

I need immediate help. I accidently deleted a table and I have no back-up.
I know that there is no excuse but I learned the hard way.
Please tell me that there is a solution!!
I am desperately waiting for good news!

Database Design 101: Always keep good backups!

You might give this article a try:

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

Good luck,

 

[Rick Brandt]

I need immediate help. I accidently deleted a table and I have no
back-up. I know that there is no excuse but I learned the hard way.
Please tell me that there is a solution!!
I am desperately waiting for good news!
Thanks
Dimitris

If you have done nothing else "Edit - Undo" might bring it back. Otherwise
you would need to contact a company that does recovery work against Access
files. One is called PKSolutions (If I recall correctly).

 

[Coleen]

Were you working from a local hard drive (C:\\) or a Network drive? If you
are working on a local drive, you might be able to go into the Recycle bin
and restore the file. If you were working on a Network drive, you'll have
to contact your network administrator to see if the file can be restored.

HTH,

Coleen

 

[Dimitris]

I saw that article. But it says it works only if the database has not been
closed since the table was deleted.
And I have closed my database since then, even my computer!
I have no idea how the table was deleted. I swear I didn't delete it, but
the table isn't there. I don't know what
happened I can only assume I accidently pressed something, eventhough I am
positive I didn't.
Is there anything I can do? Anything at all?
Thanks
Dimitris

 

[Rick B]

Are you sure the table is gone and not just "hidden"?

 

[Rick B]

Coleen,

I don't think she deleted an enmtire file, jsut a table which would not be
in the recycle bin.

(If I understand her question correctly)

 

[Jeff Conrad]

There is no harm in at least trying the code in the article.
It *should* not hurt anything if it does not work.

Keep your fingers crossed and give it a try.

If it fails, you may need to seek a professional service.

--
Jeff Conrad
Access Junkie
Bend, Oregon

in message:

 

[Dimitris]

How can I tell if the table is hidden?
Where should I look?

 

[Jeff Conrad]

Tools | Options | View Tab

Check the box called "Hidden Objects"

--
Jeff Conrad
Access Junkie
Bend, Oregon

in message:

 

[Dimitris]

No it's not hidden. Unfortunately.
Where can I get help?

 

[Coleen]

Sorry, I thought he meant he had deleted the entire db...restoring from the
recycle bin is simple, and relatively simple from the network, but in this
case - sorry, try the code in the link...as Jeff said there should be no
harm, and at the very least, you might get your table back.

Coleen

 

[Jeff Conrad]

You could try these links.
I have not (thankfully) done any business with any of these places
so I cannot speak on their track record.

Database Recovery:

http://www.pksolutions.com/

http://www.atroplan.com/

AccessFix Software
http://www.cimaware.com/accessfix.html

http://www.repair-access-database.com/

--
Jeff Conrad
Access Junkie
Bend, Oregon

in message: