Can I used trigger in MS ACCESS DB

[yassinemannai]

Hello,
I have MS ACCESS DB ( 1 table : employe ).
I attach a table ( emp ) from Oracle DataBase,
I want to insert data to "emp" from "employe"

can I write a trigger ( the same of Oracle trigger )

( when user insert data to "employe", automatically "emp" Data be updated )

please help me quickly

 

[balor]

No you can't use triggers in Access. If the user enter the employee in a form you can write code in the form to update the other table.