Might want to research SQL Replication

It's neither easy nor cheap to set up ACTUAL SQL Server replication. Mirroring a server is pricey. I do have a seminar where I show you how to copy data back and forth from Access to an online database. That's the method that I still use to this day. I copy order information down from my online server to my local Access database, and I post changes to the customer accounts back up to the server after the order is processed. Works like a champ. It's called the Access Web Sync Seminar.

Now that seminar is older, and you already have the newer SQL Server seminar, so I'm not saying you should necessarily buy it. The old seminar uses Access databases online which I don't recommend anymore. However the techniques are similar. When you edit a record in either place, you set a field "NeedsUpdate" or whatever. Have an event that runs every minute or so that copies those records back and forth.

Here's another video that shows a similar technique: Sync Remote.

Thank you very much. Hope that I'll cope with this.