Recovering table

[John]

Hi

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

Thanks

Regards

 

[John Vinson]

Hi

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

Thanks

Regards

You can type Ctrl-Z *IMMEDIATELY* after deleting the table... and it
will sometimes work. If you've closed the database... no.

I'd suggest contacting Peter Miller for his highly regarded database
salvage service at http://www.pksolutions.com. It's not free but in
this case you should have no trouble getting your data back.

And... keep current backups. They're not optional, for this reason and
because databases can become corrupted (and sometimes even Peter's
wizardry can't rescue them).

 

[Tom Wickerath]

Hi John,

See the following KB article:

ACC2000: How to Recover a Table Deleted from a Database
http://support.microsoft.com/?id=209874

While written for Access 2000, I suspect the code will work fine in Access 97, 2002 or 2003.
However, there are limitations:

a.. The database has not been closed since the table was deleted.
b.. The database has not been compacted since the table was deleted.
c.. The table was deleted using the Microsoft Access user interface.
NOTE: If multiple tables were inadvertently deleted, this function recovers only the last table
that was deleted. The other tables are lost.


Tom
________________________________________


Hi

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

Thanks

Regards