run code on table update

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

helpplez - 05 Jan 2004 14:27 GMT

Is it possible to run code when a table is updated
directly? I can do it if I create a form from the table
and put the code there. But is there a way to add code to
the table itself?
Thanks.

Reply to this Message

Scott McDaniel - 05 Jan 2004 15:06 GMT

No ... those are commonly known as "triggers" and Access doesn't support
them. Direct table data entry is not encouraged either ... tables should NOT
be exposed to users.

Signature

Scott McDaniel
CS Computer Software
Visual Basic - Access - Sql Server - ASP

> Is it possible to run code when a table is updated
> directly? I can do it if I create a form from the table
> and put the code there. But is there a way to add code to
> the table itself?
> Thanks.

Reply to this Message