Monitoring a database for changes with ADO
Posted on 2002-05-13
I am trying to monitor a database for additions, changes or deletions. The changes come from a third party app that I do not have source for. I know the app uses ADO because it installs the latest version of ADO when it is installed.
I need real-time performance from the database so I've decided to cache all the data in memory while my application is running.
However, to keep the cache up-to-date with the database, I need some way of being notified when a change takes place so I can update the cache.
Will ADO provide the kind of events I'm looking for?