469,621 Members | 1,688 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,621 developers. It's quick & easy.

HELP: how to recover deleted record from a Table

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
1 7307
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.

Similar topics

5 posts views Thread by Grant | last post: by
4 posts views Thread by Don Sealer | last post: by
reply views Thread by devrayhaan | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.