Simultaneous Updating Continuous Form/Multiple Users

[robrich22]

I have a main form, which is a continuous form that displays jobs with start/end times. My database is split into BE/FE. The frontend resides on the individual users pc. Now there are normally 5 people entering data into the application. If one user updates a job in the continuous form/deletes/adds a job, I want that update to be pushed to all clients, so it shows up on their screen immediately after being entered. What's the best way to do this?



I am thinking of maybe using the Timer control on the main form to check a field in the database for last-updated, and if the time is different, then it will requery the form to get the updates? Is this is best solution, or are there any other ways? The timer could fire off every 10-15 seconds?

Thanks

[orange]

Just a thought, but could you filter the data underlying the Form that everyone uses, such that each user worked on his/her subset of records. That way nobody should be updating/deleting records that are outside his "realm of influence".

It may mean a change in work procedures, but I have used similar approach when updating records with several clients.