If I understand what you are asking, then the database backend will take care of the updates and you would be able to see the changes immediately no matter where you are connecting from.
Now is this Access backend going to be on a web server or in some other location? Either way, if you are using the .Net framework, you can manage multiple connections to the database backend without much trouble. Are the three locations already networked together using a WAN? If not, you may need to set up a VPN or something along those lines.
Chester
cpopham
Junior Poster in Training
65 posts since Mar 2005
Reputation Points: 10
Solved Threads: 0