Edit date on MS Access table

[ideafixer]

Is there any easy way to capture when a record is edited in a Access 2000 table? A last edit date time?

 

[PaulBricker]

Not if the changes are being made directly in the table. If the changes are being made from a form bound to the table then you can use the Dirty Property or the On Change Event or something like this to capture the Date/Time of the system clock and insert that value into a field in a table.

Paul