can access use triggers?

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hello,

I am wondering if access can use triggers like sql server? I want to
be able to update a column called updated when a record is modified. Thanks
in advance.

John
 
John,

No, Access does not have triggers; it has events. To do what you want -
from a Form - you would use the BeforeUpdate event with the following code:

me!Updated = Date()

hth,
 
Back
Top