监听ms access \触发器操作中的更改 [英] Listen to changes in ms access \ trigger manipulation

问题描述

O.k，大Q在这里：

我知道这是一个很大的主题，我不能期望在一天内解决它。

也，我希望它不要懒得我问（好吧，我确实谷歌了很多）但是这里是：

我们公司的主要软件（开发）在vb6）关注簿记。这是一个庞大的程序，大约150万个代码行。我们使用的数据库（以及我们的客户端）是ms访问。最近，我开发了一个主要软件的消息中心（vb.net），它支持收听主软件数据库，并根据内部的变化发送短信。

例如，以低于盈利能力的价格从商店出售商品的客户将使用此信息向商家所有者发送短信。

现在，我知道在sql server中有触发器这样的东西可以在.Net代码中操作。但是，我需要知道ms访问中是否还有这样的东西。有没有办法我可以听取访问数据库中的更改（当然，没有使用像扫描计时器这样的愚蠢方法）并根据此更改在消息中心内进行操作？

拜托，我知道这个是一个很大的主题，但任何帮助将是最受欢迎的。

谢谢你的头，

oron。

O.k, the big Q is here:
i know this is a huge subject and i cant expect to solve it in one day.
also, i hope its not to lazy of me to ask (well, i did google it a lot) but here goes:
Our main software in the company (developed in vb6) concern bookkeeping. this is a huge program, about 1.5 milion code lines. the data base we use (and so our clients) is ms access. Recently, i developed a message center (vb.net) for the main software which suppouse to listen to the main software data base and according to the changes made inside, send sms.
For example, a client who sold an item from the store at a price lower than its profitability will send SMS to the owners of the business with this info.
Now, i know that in sql server there is such thing as triggers which can be manipulated in .Net code. however, i need to know if there is such a thing in ms access as well. is there a way i can listen to changes made in access database (without, of course, using stupid methods like scan timers) and according to this changes act inside the message center?
please, i know this is a big subject but any help would be most appreciated.
Thanks a head,
oron.

推荐答案

如果您使用的是MSAccess 2010或更高版本，则可以使用数据宏 [ ^ ]



如果您使用之前的版本（可能是VB6）并且是无法升级然后你必须找到另一种方式。



但是，我不认为你能用外部程序与触发器进行交互在VB.NET中。您最多可以将SMS详细信息放在队列（表）上，并按设定的时间间隔监视VB.NET程序

If you are using MSAccess 2010 or later then you can use a Data Macro[^]

If you are using a version prior to that (likely with VB6) and are unable to upgrade then you will have to find another way.

However, I don't think you are going to be able to interact with a trigger with an external program in VB.NET. At best you will be able to put the SMS details on a "queue" (table) and have the VB.NET program monitor that at set intervals

这篇关于监听ms access \触发器操作中的更改的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！