| | |
|
|
|
Recovering table |
|---|
| message from John on 11 May 2004 |
Hi
Is it possible to recover a table if it has been deleted and before the mdb
file has been compacted?
Thanks
Regards
|
| Tom Wickerath replied to John on 10 May 2004 |
Hi John,
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
________________________________________
"John" <john@nospam.infovis.co.uk> wrote in message news:O6Mpy$uNEHA.1908@TK2MSFTNGP12.phx.gbl...
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 replied to John on 10 May 2004 |
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).
John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public
|
|
Archived message: Recovering table (Microsoft Access Error Message)
