我可以像在SQL Server等其他数据库中一样在MS Access中插入触发器吗？ 您使用的是Access 2010吗？如果是这样,你可以使用 Access 2010 data macros *,否则你运气不好. Access 2010 data macros (similar to tr
Access 2010 data macros (similar to triggers)
by Access Team on August 13
Last week we outlined improvements to the Access 2010 macro
designer, parameter support, and IntelliSense. These improvements
build upon Access 2007 macro improvements of macro sandbox, embedded
macros, TempVars, debugging, and support for error handling.The natural next step in macros is to provide a model for business rules. Data macros allow developers to attach logic to record/table events (similar to SQL triggers). This means you write logic in one place and all forms and code that updates those tables inherit that logic. Here are a few data macro scenarios you might find in a typical Donations Management database: