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

HELP: how to recover deleted record from a Table

P: n/a
Hi all,

there is a utility o procedure to recovery deleted record from a Access
table (versione 2002/2003) ?

Thanks in advance

Roberto
--
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG
Nov 28 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Mon, 28 Nov 2005 17:33:16 +0000 (UTC), "Roberto La Forgia"
<ro**************@virgilio.it> wrote:
there is a utility o procedure to recovery deleted record from a Access
table (versione 2002/2003) ?
Don't know about a utility, but a previous discussion...

Q&A copied from the internet I deleted one of my tables in my database by mistake (Access 2),
and I have no up-to-date backup. Is there any way I can restore
my data? (I didn`t compact my database after this accident).


Have you done anything? Look in the MSysObjects table for anything
starting with a "~" one of these might be your table. When you delete
a table or other object Access sets a flag that indicates the object
should not be displayed in the database window and changes the name
to something like ~TMPCLP-297881. Now, usually these objects will
remain in your database until it is compacted, but not always. To
recover the data in a deleted table make a query like this

SELECT * INTO new
FROM [~TMPCLP-297881];
John Thomas Smith
http://www.direct2usales.com
http://www.pacifier.com/~jtsmith
Nov 28 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.