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

Recovering table

P: n/a
Hi

Is it possible to recover a table if it has been deleted and before the mdb
file has been compacted?

Thanks

Regards

Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
If you haven't done anything at all since the delete, Undo will return it.
If you've gone beyond that, you'll need to restore from a backup or send the
file to a data recovery shop.

--
Wayne Morgan
Microsoft Access MVP
"news.dsl.pipex.com" <jo**@nospam.infovis.co.uk> wrote in message
news:40*********************@news.dial.pipex.com.. .
Hi

Is it possible to recover a table if it has been deleted and before the mdb file has been compacted?

Thanks

Regards

Nov 12 '05 #2

P: n/a
"news.dsl.pipex.com" <jo**@nospam.infovis.co.uk> wrote:
Is it possible to recover a table if it has been deleted and before the mdb
file has been compacted?


Possibly.

Delete Records or Deleted Tables from Microsoft Access MDBs
http://www.granite.ab.ca/access/deletedata.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Nov 12 '05 #3

P: n/a

On Tue, 11 May 2004 01:35:22 +0100, "news.dsl.pipex.com"
<jo**@nospam.infovis.co.uk> wrote in comp.databases.ms-access:
Is it possible to recover a table if it has been deleted and before the mdb
file has been compacted?


Yes, it is entirely possible to recover not just one deleted table,
but all deleted tables and their data within a database that has not
been compacted, and this is true regardless of whether you have closed
Access since deleting the tables. It is true when Undo fails. It is
also true even when the solution Msft posted in the kb fails (that
solution applies to just a single deleted table in a limited set of
circumstances).

Peter Miller
__________________________________________________ __________
PK Solutions -- Data Recovery for Microsoft Access/Jet/SQL
Free quotes, Guaranteed lowest prices and best results
www.pksolutions.com 1.866.FILE.FIX 1.760.476.9051
Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.