In Oracle databases I previously used triggers to track record updates within tables. I could set a trigger up at the table level so any time a record had a field updated, the date and time would be recorded in a related field within the same table. This trigger would be applied no matter how the record was updated (form, query, procedure, etc.).
I am now trying to find out if there is a similar tool in Access. I can set up an After Update event logging function, but I have to set this atthe form level – so every form accessing the table needs to have this event added. Can I easily set up something on the table level?