are there 'trigger' in Access?

[Mohammed Aziz Matin]

can some one tell me if there are triggers in access like the ones they have
in PL/SQL. and if there are, how i can use it.
thanks

 

[Kevin3NF]

Nope. The closest you can come is to use form events such as 'After Update'
to execute some code...

Unless your back-end is SQL Server, in which case you can use triggers.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

 

[Van T. Dinh]

No.

Generally, Form Events are used to simulate triggers.

 

[Albert D. Kallal]

Well, actually, the answer depends on how you use ms-access.

Ms-access is really only the interface tool to a database. So, the database
part is not really in ms-access.

If you use a adp project in ms-access, then you do have triggers and even
stored procedures. So, depending on how you use ms-access, the answer will
vary.

Ms-access comes with two database engines. One engine is the MSDE, and it is
the equivalent of sql server. This engine has triggers and stored
procedures.

The other data engine is called JET, and when you use JET, you don't have
triggers. You can as others mentioned use the before update events in a
form.