<div>
DrSQL<br />
<br />
Thanks for your comments.<br />
<br />
The third party app uses either SQL Server or dBase depending on what the user selects at install time. &nbsp;I think the default is dBase.<br />
<br />
I considered the trigger approach but wasn't sure if my program could add triggers to another application's database. &nbsp;I should do more research and experimentation.<br />
<br />
I was intrigued by the ADO approach since two more third party apps we have to work with actually generate COM events when they update their databases...though there databases are in a proprietary format.<br />
<br />
But if ADO won't do the trick, I'll follow your suggestion.<br />
<br />
Thanks<br />
John
</div>


DrSQL

Thanks for your comments.

The third party app uses either SQL Server or dBase depending on what the user selects at install time.  I think the default is dBase.

I considered the trigger approach but wasn't sure if my program could add triggers to another application's database.  I should do more research and experimentation.

I was intrigued by the ADO approach since two more third party apps we have to work with actually generate COM events when they update their databases...though there databases are in a proprietary format.

But if ADO won't do the trick, I'll follow your suggestion.

Thanks
John

<div>
<div class="content wysiwyg-content">
I am trying to monitor a database for additions, changes or deletions. &nbsp;The changes come from a third party app that I do not have source for. &nbsp;I know the app uses ADO because it installs the latest version of ADO when it is installed.<br />
<br />
I need real-time performance from the database so I've decided to cache all the data in memory while my application is running.<br />
<br />
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.<br />
<br />
Will ADO provide the kind of events I'm looking for?
</div>
</div>


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?

Monitoring a database for changes with ADO

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.