Link to home
Start Free TrialLog in
Avatar of CalvinDay
CalvinDay

asked on

How do I undelete records in Access 2000

Is this possible to do?
ASKER CERTIFIED SOLUTION
Avatar of flavo
flavo
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
If you have a backup, you may be able to restore them that way, otherwise...dave is correct...the answer is nope.

Mike
Dave,
   I can't sent e-mail.  Won't be able to until the morning.

Mike
Did it work? Quick yes or no?
yes and no...more tomorrow...Mike
cr@p!  Catch you later, im off for a site visit..
let me guess, report bombed out?  Could never test install on non VS pc :-(
I have my laptop at work, and finally got my rights on my pc (win installer was broken) ill see what i can do on lunch
Avatar of LenaWood
LenaWood

Calvin,

In my databases I don't ever delete a record until I know for sure that it will never need to be seen again.  I put a Yes/No Field in my table and run an update query off of a command button when the user wants to "delete" the record.  In my reports I make sure I set the criteria for this yes no field to False so that any records marked "deleted" won't show on reports.

Lena
Avatar of CalvinDay

ASKER

I am writing a program using Delphi and ADO with Access or MS SQL as a back end. I was experimenting with deleting orphaned records. It worked. Unfortunately, I wiped out all of my test data that I had entered. I have paper backups. It's time to get typing.
So sorry Calvin...I have been there and done that....thankfully only a couple of times.  Good luck on your project!

Lena