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 
