Quote Originally Posted by gibra View Post
In addition to what indicated by Olaf, I suggest a variant of point 2 Terminal Services (TS), but more powerful and performing: XenApp / XenDesktop by CITRIX.
Citrix is ​​the company that invented the TS technology later adopted by Microsoft, but obviously continued the development on its own.

In practice, you need a dedicated virtual server on which you can 'publish' all the apps and / or desktops you want.
In both cases it is accessed via a browser (on the client PC only the Citrix Receiver is installed), and the difference between XenApp and XenDesktop is that in the first case the user accesses the program via an icon, in the second it will have a remote desktop.

Obviously you have a manager available to configure users, permissions, etc ...
We in the company have dozens of users who connect from all over the world even with connections that are not always good and we have never had speed problems. The SQL Server is located in the company, not on the cloud.
Among other things, since sometimes users have to go to sites without internet connection, I had to create for a specific application also a version that works OFF-LINE (records data on a local MDB database) which then synchronizes 'with the server when the user can connect ONLINE.
But that's another story.
Thanks for your post, i am most grateful too.
From what you said, after moving the App and Database to the cloud, it would be much better for the Client systems here to access App via XenApp / XenDesktop by CITRIX.
I have opened up the Citrix website and reading up their Virtual App and Desktop product. I would update you as things unfolds.
If all this works and there is no significant difference in speed, i would be on the moon in appreciation.