MS Access sync
Posted on 2014-07-24
My company has MS Access(2007) database that connected to ERP system locally in the network. The ERP and MS Access can't not be changed for anything. It will stay as it.
Now I want to a eCommerce website to write/read the MS Access (Basically, allow customer to purchase products on line). Just like if order is created on the website, the inventory inside of the MS Access database will be reduced, as a example. What is the best solutions? Replicate the MS Access or syn out to the cloud? Or something else...
The bandwidth in the company office is not very fast 1.5 up/down.