assuming i have microsoft access database called "LocalDB" with just one table called "Items".
also, i have software for booking managment. the software always insert, update and delete records from "Items".
Now, beside that software, i have an external software and we name it "smsCenter".
the "smsCenter" wait for changes to be maid in "LocalDB\Items", and that specific change is sent by sms to the user. here's an example:
the user gets an interface through which he can choose the category to follow changes. lets assume he choose "Price".
i just now update my item price from 0.99$ to 1.99$. the field "Price" in "Items" changed its value from 0.99 to 1.99. "smsCenter" catches that change and send the next sms to the user: "Dear user, the price for item no. 552356 updated from 0.99 to 1.99".
so, i need to listen to changes in the "Items" table. for that, i need to build an interface through which the user could choose the category to follow and the parameter to choose (e.g: get sms if price lower then x or higher?).
Now, the most important thing is that i can not do any changes in my booking software. our software include 1.5 milion code lines and it is immposible to change it (also, its written in vb6). so, i need to build an interface and that interface will create datamacro in my "LocalDB". the data macro will listen to changes in the choosen field and write the change to specific table called "TempTriggers". the "smsCenter" will listen to "TempTriggers" and send the sms. my big question is how can i write data macro to access database using an interface written in vb.net?
I am aware that my question is not focused on one thing certain and that a big topic but I need to know where to start. Can anyone tell me if there is a way to generate macro code using vb.net?
hope i was clear enough :)
Submit an article or tip