I have an application in WPF + MS ACCESS where users make registrations, queries, etc. The main server is located in SP, but we have branches in RJ, BA, MG, PR, RS, GO, etc., which also access the tool. Due to connection problems at these branches, it turns out that a simple SELECT takes too long to execute and the connection does not end up falling. We thought of replicating this database to the local PC and making a robot (console) to update both the local base and send the information to the SP central DB.
Thinking that what I have in hand is only the MS ACCESS and VS2013 , this is the best way to solve this problem? If not, what would be a better way?