ASP.NET与MS Access结合时,如何创建数据库触发器?

更新于
2026-09-26 19:38:32
25阅读来源:SEO资源
  • 内容介绍
  • 文章标签
  • 相关推荐

本文共计234个文字,预计阅读时间需要1分钟。

ASP.NET与MS Access结合时,如何创建数据库触发器?

在MS Access中插入触发器,您可以使用Access 2010的数据宏功能。如果您使用的是Access 2010,可以直接使用数据宏来创建触发器。如果您觉得数据宏不够方便,可以考虑使用其他方法。

ASP.NET与MS Access结合时,如何创建数据库触发器?

我可以像在SQL Server等其他数据库中一样在MS Access中插入触发器吗? 您使用的是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:

本文共计234个文字,预计阅读时间需要1分钟。

ASP.NET与MS Access结合时,如何创建数据库触发器?

在MS Access中插入触发器,您可以使用Access 2010的数据宏功能。如果您使用的是Access 2010,可以直接使用数据宏来创建触发器。如果您觉得数据宏不够方便,可以考虑使用其他方法。

ASP.NET与MS Access结合时,如何创建数据库触发器?

我可以像在SQL Server等其他数据库中一样在MS Access中插入触发器吗? 您使用的是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: