SQL Server Performance Forum – Threads Archive
MS Access triggersHello 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
There are no triggers in MSACCESS
http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=7497 for relevancy. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.
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.