Update data in VB6 after access table has been updated from others app

[dechalu]

One application write data in access 2000 (one record/min)
a client application has to show the refreshed data in a textbox and start calculation.

How can I detect table update in my client application?
How can I use handle from one App. to the other.

I use VB6, I tried already "WithEvents" and "FieldChangeComplete" but this works only inside of the same application.

Thanks Lucas

 

[freewilly]

You could try getting a count of the records in the database every few seconds or at a suitable interval.

Other than that i have no idea. SQL Server could do it but i can't think of how access could.

Good Luck