Ok are the branch PCs in question on an Intranet?

If so map the database drives to your central Server. This will allow you to view all dbs in one virtual location, making the coding simpler. Use this approach at a client's site for a national sales db with good results.

Oh make sure that you can share the new mapped drives, My Computer -> Drives -> Sharing