MS Acess 2000 Table recovery

[Danny]

Is there any way to restore a deleted table? I have not
compacted the database but it has been closed.

 

[Allen Browne]

According to:
http://support.microsoft.com/?id=209874
you may be able to recover a deleted table, but it does say before the
database is closed.

It may be worth a shot anyway. Make a copy of the file in its current state.
You may even like to try putting the code into another database, and using
OpenDatabase() instead of CurrentDb().

 

[Peter Miller]

Is there any way to restore a deleted table? I have not
compacted the database but it has been closed.

Allen's advice should be heeded. Under certain circumstances, it is
possible to undelete a table given the sample code on Msft's site.

And John is likewise providing good advice. When a deleted table
'appears' to be unrecoverable given the sample code, we can virtually
always still recover such tables. In fact, if you delete ALL the
tables in your database, we can still recover 100% of the original
file. The sample code from Microsoft is based on a technique that can
never recover more than one deleted table, and even then, fails unless
very specific conditions are met.

We'd be glad to recover your data for you if you wish, and we
guarantee we will be successful.

Peter Miller
____________________________________________________________
PK Solutions -- Data Recovery for Microsoft Access/Jet/SQL
Free quotes, Guaranteed lowest prices and best results
www.pksolutions.com 1.800.987.7716 1.619.839.3900