Hello Richard, Just a little naive question: Would it be possible to use the SQL database locally, e.g. through the Express Mgt Studio, in order to be faster for the office users, and at the same time, to bridge the local server with the SQL Server (e.g. which is on Winhost), in order to have my safe backups and be able to work through this online server, at the same time? Thank you very much, in advance.
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.
Despina KarayanniOP
@Reply 4 years ago
Thank you very much. Hope that I'll cope with this.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access SQL Server Lessons.
