Does table update trigger an event?

  • Thread starter Thread starter Ynot
  • Start date Start date
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.
 
Ynot said:
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.
Click to expand...

No. What you're describing is a Trigger and Jet (the default database in
Access) doesn't support them. You can use an Access app as the front end to a
server database (like SQL Server) and then have triggers for such things.
 
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)
 
Back
Top