asp.net - 在 MS Access 中触发

Question

我可以像在 SQL Server 等其他数据库中一样在 MS Access 中插入触发器吗？

Answer 1

您使用的是 Access 2010 吗？如果是这样，您可以使用Access 2010 data macros *，否则你就不走运了。

<小时/>

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: