Originally Posted by
turbofish
Since remoting into the machine is not an option, this is one of those cases where you could use Access for the front end but you really need to use SQL server to take advantage of replication. In this case, merge replication would be the best especially when dealing with a disconnected model. That way if you have a slow connection or even if you loose your connection, as soon as a connection is reestablished, replication will get the data caught up without any real fear of corruption. Depending on an Access database file across a network that is 20 k away would guarantee a future bad day.
I have used this method to keep 130 different remote locations up to date that were located in 11 different states. Heck, now even our database is located 120 miles away from our corporate office.