I have a shared split database on the network (database is on the network and front end on the workstations).
What is the best method for updating, I.E.
One user inputs his work load for the week and the boss is waiting to see it on his workstation without any interaction with the program (closing and opening the app or refresh button).
My solution is to requery every 10 min. utilizing on timer & timer interval.
Is there a better method? -Is it possible to send a requery to the boss (or all users) only when a user inputs workload (projects to work on for the week)?