I am currently working on a project that queries an access database. A the moment it is a single user system, but my supervisor has asked me to change it ot a multi-user system so that mulitple users can run mulitple instances of the system, but using the same underlying datasource.
To do this effectively I will need a way of notifying all instances of the system when a change is made to the database so that they can refresh their data. I thought that one way of doing this could be to provide a proxy interface to the database so that the instances of the system do not query the database itself, but instead pass the queries to some interfacing system that performs the query and then notifies all registered instances of the system.
But this is all very generic and was wondering if anyone had any programming specific implementations of similiar solutions.