<div>
<div class="content wysiwyg-content">
I have a shared split database on the network (database is on the network and front end on the workstations).<br />
<br />
What is the best method for updating, I.E. <br />
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).<br />
<br />
My solution is to requery every 10 min. utilizing on timer &amp;&nbsp;timer interval.<br />
<br />
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)?
</div>
</div>


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)?

MS Access What is the best way to update form data for multiple users?

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.