CalvinDay
asked on
How do I undelete records in Access 2000
Is this possible to do?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Dave,
I can't sent e-mail. Won't be able to until the morning.
Mike
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 :-(
yes
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
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
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
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
Lena
Mike