Forum Discussion
Migrate Access DB to Cloud
Blockers? Probably performance is going to be the most significant.
I've done something like this for a handful of clients and that has always been the number one problem. However, we did not use an Azure VM; we connected directly to the Azure database. Therefore, I can't say that a VM would or would not make a difference. And, of course, we didn't try to map a drive in that configuration.
Keep in mind, with any cloud solution, you're pushing and pulling data across a much longer wire.
Also, network performance, internet connectivity and all that tend to be more critical to success.
Hitesh_Jansari Using a VM to host the Access and trying to map it is a bad choice.
Access is very touchy when it comes to network, it want's it to be solid,fast without any lag,so Internet is a no go as moving your file server to the cloud.
The 2 options are
1. RDS, host Access to it and RPD it...pros : it would be very fast and convenient, cons: then license price
2. Cloud BE, you will migrate the tables to SQL ,pros : a lot, cons : it requires quite some work to make it work as it should...remember SQL is not a file server, so don't treat it like one.
tsgiannis Agree, not great using AccessDb in the cloud. We are looking using PowerApp to remediate some of these for tactical solution.