Hi.
One can recover the last deleted table in the database, as long as no other
operations have taken place, such as deleting or copy/pasting another table,
and the database has not been closed or compacted, and the table was deleted
using the user interface, not from code.
Just open the Database Window to the "Tables" tab and press <CTRL><Z> to
undo the delete operation. If that doesn't work, you may be able to run
some code to recover the last deleted table, but don't get your hopes up.
Please see the following Web page for instructions:
http://support.microsoft.com/default.aspx?id=209874
"Deleted" tables are marked for deletion, but aren't removed from the file
until compaction. Remember that anything "marked for deletion" is
overwritten by Jet as it updates other data within the file. If the table
has been altered from an earlier version of the structure, original parts of
the table structure _can_ remain under certain circumstances, but it's very,
very difficult and time-consuming to retrieve this by data recovery
services, which means it's expensive and not guaranteed to recover the
original data.
Data recovery services can often retrieve what's left of the deleted tables,
but this is also costly and usually not very useful, since one needs to
remove the parts that were overwritten by Jet, which leaves gaps in the data
in the records.
Your best bet is to restore from the most recent backup. You do have
reliable backups, don't you?
HTH.
Gunny
See
http://www.QBuilt.com for all your database needs.
See
http://www.Access.QBuilt.com for Microsoft Access tips.
(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Thanks,