MS Access 触发器? [英] MS Access trigger?
问题描述
我在 MS Access 中有两个名为 [Insert_Record] 和 [Delete_Record] 的表.两个表有相同的字段,但一个表有记录,而另一个表没有记录.
I have two tables named [Insert_Record] and [Delete_Record] in MS Access. Both tables have the same fields but one table has records whereas another table has no record.
问题:我希望,每当我从表 [Insert_Record] 中删除任何记录时,整个记录都应自动插入到另一个表中,即:[删除记录].
Question: I want, whenever I delete any record from the table [Insert_Record] that entire record should automatically insert into another table, i.e: [Delete Record].
我怎样才能做到这一点?
How can I accomplish this?
推荐答案
Access 2010 引入了事件驱动 数据宏,类似于触发器.问题中描述的过程可以通过 [Insert_Record] 表上的 After Delete 数据宏轻松完成:
Access 2010 introduced event-driven Data Macros that are similar to triggers. The process described in the question can easily be done with an After Delete data macro on the [Insert_Record] table:
这篇关于MS Access 触发器?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!