Last modified Record

[Guest]

Last modified Record

Is it possible to trace the last modified record.

There are more than 5000 records. There was a changes done in one particular
record ( in one numeric field of that record). Now I forgot and am unable to
trace which was the record that I edited.

Note : From that time onwards I have not added nor modified any more
records. As I am trying to save a lot of time if I get a solution to do this.

If possible, pleaase advise me.

Regards.

Irshad.

 

[Lynn Trapp]

Do you have a date field in the table for storing the date and time of when
the record was last modified? If not, then you are probably out of luck. I
always put the following fields in tables that I need to track:

Created_By
Last_Updated_By
Creation_Date
Last_Update_Date

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html