General discussion

Locked

MS Access "Triggers"?

By OrangeStripe ·
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?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Related Discussions

Related Forums