Hi Guys,

Just a fairly general question here about how to keep database driven app's on screen data up to date.

I'm connecting to an SQL server to retrieve information on which employee's are signed in or out of the building in our company. My program also modifies the SQL table to update when new employee's have signed in or out. This is all fine when my app is just being run on one machine (which is how its setup now) but I have been asked to set this up on another machine in another office, so both PCs will be running my app and both will be modifying the SQL table.
The on screen data at each PC needs to be as up to date as possible because if there is a fire in one office then the list of signed in employees shown on screen at the other PC is used as the fire register.

So yeah, is my only option to use a timer that just runs every minute or something and updates all of the data in my program to the most current or is there a better solution? (loading all of the SQL table data could take between 10 and 20 seconds when the network is going slow so I want to avoid having to do that every minute if possible)