我如何...创建一个在Access数据库中创建XML的触发器 [英] How do i...create a trigger for creating an XML in access database

问题描述

如何使用trigger在microsoft access数据库中完成更新时创建xml文件.Kindly给出一个示例代码



我尝试过：



由于我没有在访问数据库中工作，我根本不知道。

how to create an xml file when a updation done in microsoft access database using trigger.Kindly give a sample coding

What I have tried:

As i havent work in access database i have no idea about it.

推荐答案

Access不支持触发器。使用标准SQL技术无法实现您的目标。



您必须在VBA中编写代码来处理您想要的INSERT / UPDATE / DELETE函数执行一些触发操作，并在VBA中完成任何你想做的事情的代码，以做任何类似触发的事情。

Access does not support triggers. What you want to do isn't possible using standard SQL techniques.

You have to write the code in VBA that handles INSERT/UPDATE/DELETE functions to which you wanted to perform some trigger operations and write the code for whatever you wanted to do completely in VBA to do anything resembling a trigger.

这篇关于我如何...创建一个在Access数据库中创建XML的触发器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！