Does table update trigger an event?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ynot - 17 May 2005 01:45 GMT

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.

Reply to this Message

Rick Brandt - 17 May 2005 02:30 GMT

> 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.

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.

Signature

I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Reply to this Message

Van T. Dinh - 17 May 2005 02:33 GMT

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)

> 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.

Reply to this Message