We help IT Professionals succeed at work.

Undelete Access table

nickhoggard
nickhoggard asked
on
Hi everyone,

I've just gone and done something very stupid, and I'm hoping someone knows of a way to reverse it.

When copying data from 2 different versions of the same access table, I accidently copied the older version of a table over the newer version :-(

I'm not sure if there is a way to reverse this, but I thought I'd ask before I go throught the process of manually reentering everything.

Cheers
Nick
Comment
Watch Question

Ryan ChongSoftware Tead Lead / Business Analyst / System Analyst / Data Engineer
CERTIFIED EXPERT

Commented:
Ctrl + Z (Undo) ?

and make sure you backup the file before execute your process.
DSS

Commented:
Start Typing!

Author

Commented:
Undo was the first thing I tried, and I've also tried a couple of VBA undelete functions I downloaded.  Still no luck though :-(

Commented:
Nick,

Normally you can only get this back from a backup...

When you pasted the older table, didn't access create a tablename1 version ? Thats normally the case when you add a table that's already present.

Otherwise DSS is right: Start typing....

Nic;o)

Author

Commented:
Hi everyone,

Thanks for your input.  I havn't been able to restore everything, but I did eventually find an old backup in the recycle bin of another computer.  At least that one was only about 100 records short :-)

As a future precaution, is there any form of logging that can be enabled for Access?  I know on many other databases (I admit these are usually a lot larger than Access) log all transactions.  Does Access do this anywhere that is accessable?

Cheers
Nick
Access does NOT provide a LOG capability -- one of several reasons why Access is not generally used for SIGNIFICANT database development, without a lot of thought. (Access should not be used for an Enterprise-wide application, for instance)
Jim Dettman (EE MVE)President / Owner
CERTIFIED EXPERT
Fellow
Most Valuable Expert 2017

Commented:
Arthur (and others)

Actually, Access/MSDE does offer transaction logging.  It's Access/JET that does not.

Now that there is an alternate database engine, you have to be carefull not to make blanket statements like "Access does NOT provide a LOG capability".

I've already caught myself a few times on this.

Nick:

As far as the table undelete, Ctrl/Z is it (the code that's floating around does the same thing), so a backup is it.  

And most likely, even if you had transaction logging, it probably would only take you to the last backup anyway.

Jim.
but MSDE ONLY applies to Access 2000+ - and since no mention was made of which Access version was being used, I made the basic assumption of the lowest common denominator (Access 97 or earlier).

Commented:
for nickhoggard

It's time to clean up this TA, so I will leave a recommendation in Community Support that this question is:
 - PAQ'd and pts refunded
Please leave any comments here within the
next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !

Nic;o)
Points refunded and moved to PAQ

** Mindphaser - Community Support Moderator **

Explore More ContentExplore courses, solutions, and other research materials related to this topic.