Click here to Skip to main content
15,867,308 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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.
Posted
Updated 2-Jun-15 3:58am
v2

1 solution

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
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900