Does table update trigger an event?

Y

Ynot

Is there anything that triggers event when tables are updated?



What I want to do is log the activity any time a record is inserted or
changed in a table. I'm not sure of everyplace this table is updated so an
after update or after insert event would be perfect but I don't know how to
do that. Any help is appreciated.
 
V

Van T. Dinh

There is no trigger in JET / Access database.

For this sort of requirements, you need to ensure that all data entry / edit
are done through an Access Form (i.e. not through DatasheetView of Tables /
Queries) and use the Form_AfterInsert / Form_AfterUpdate Event and VBA code
to record the activities.

See Allen Browne's Web site:

http://www.allenbrowne.com/AppAudit.html

HTH
Van T. Dinh
MVP (Access)
 
Top