SQL Server Performance Forum – Threads Archive

MS Access triggers

Hello I’m familiar with triggers in the MS SQL, However I need to write triggers or the MS Access, and I don’t have an idea where to strat and to write triggers for it.
Can anyone provide me with a start up to this
Thanks
Mosh mosh

There are no triggers in MSACCESS

http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=7497 for relevancy. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

From
http://www.aspfaq.com/show.asp?id=2195 Triggers ——————————————————————————– In SQL Server, triggers allow you to perform operations in response to certain events without slowing down the calling application. For example, you could have SQL Mail send you an e-mail after every five inserts to the ORDERS table where the order total is greater than $50. With Access, you would have to create a table, store a count for the number of times such an insert occurs, and code the application to send mail at insert time (which slows down the application itself). Not the prettiest solution.

]]>