A very small part of my current app requires me to read an existing Access 97 table containing a single record and to display the contents of a field as soon as they are changed.
I have no control over how or when the data is placed into the Access table (it is a call logging output).
Currently I am using a timer in the vb.net app to refresh the dataset and then check if the data is changed before displaying if necessary. All I actually want to pass is a single telephone number of type string and relatively short length (up to 30 chars) to my app whenever it changes.
This is a small multi user system with the .net app potentially running concurrently on a number of PCs. Is there a sensible way to detect that the data is changed in the server based Access db table without diectly reading it and therefore creating constantly repeating server disc reads from each of the workstations?
I am able to add a routine into the Access db if necessary. So I suppose it could check itself on a loop or timer but I still can't work out how to pass the changed data to my .net app. It feels like I should create a message transmit/receive type situation shared between the two apps but I haven't a clue how or even where to start looking.
Does anybody have any ideas? Yours hopefully...
I have no control over how or when the data is placed into the Access table (it is a call logging output).
Currently I am using a timer in the vb.net app to refresh the dataset and then check if the data is changed before displaying if necessary. All I actually want to pass is a single telephone number of type string and relatively short length (up to 30 chars) to my app whenever it changes.
This is a small multi user system with the .net app potentially running concurrently on a number of PCs. Is there a sensible way to detect that the data is changed in the server based Access db table without diectly reading it and therefore creating constantly repeating server disc reads from each of the workstations?
I am able to add a routine into the Access db if necessary. So I suppose it could check itself on a loop or timer but I still can't work out how to pass the changed data to my .net app. It feels like I should create a message transmit/receive type situation shared between the two apps but I haven't a clue how or even where to start looking.
Does anybody have any ideas? Yours hopefully...