如何使用VM将MS Access FE连接到BE表
在我提出问题之前，请允许我提供背景信息。 我在网络方面只有足够的文化才能让我快速陷入困境。 因此，我说我正在开发一个Access数据库（使用VBA编码）项目，意图是通过一个互联网选项部署
数据库，Access将接受将后端的表（程序和安全性）链接到多个前端，我将分发。 所有用户，包括我自己都是游戏爱好者，而不是商家，所以"最便宜"的用户。
替代我是必不可少的。 因此，我将Azure视为我的主要场所或其他云服务（如果此应用程序可行）。 我们最多有35位用户，他们将使用运行时版本的MS Access，但有一些例外情况。 在创建虚拟机并在我的机器上进行测试之前，我希望
能够获得令人放心的自然响应。 这是我的问题：
Before my questions, please allow me to provide a background. I only literate enough in networking to get me into trouble real fast. So with that said I am working on an Access database (Using VBA coding) project and the intent is deploy the database via an internet option that Access will accept to link tables (program and security) in the Back End to the multiple Front Ends, that I will distribute. All users, including myself are gaming hobbyists and not a business, so "cheapest" alternative to me is essential. Hence I am looking at Azure as my primary venue, or another cloud service (if viable for this application). We will have up to 35 users, who will use Runtime versions of MS Access with a few exceptions. I want to get a reassuring response of natures before creating a VM and testing on my machine. Here come my questions:
1. VM是允许MS Access完成链接过程的最佳选择吗？
1. Is a VM the best choice to permit MS Access to complete the linking process?
2. 如果我在MS Access中设置连接IP并分发给前端的用户，他们是否需要在他们的计算机上设置网络以连接到VM？
2. If I set the connection IP in MS Access, and distribute to users in the Front End, will they need to set up a network on their machines to connect to the VM?
3.  ;如果我必须为每个用户设置一台远程计算机，可以通过软件打包吗？ 如果是这样，有什么软件？ 或者，我是否必须远程连接并自行进行连接？ 我意识到速度不会很好
3. If I have to set up a remote machine for each user, can that be packaged via software? If so, what software? Or, do I have to connect remotely and do the connections myself? I realize speed will not be great
这应该让我开始，我已经在本地测试了数据库，并且正在使用FE和BE连接。 它的全部内容是如何使用户友好部署。 提前感谢您，如果您需要提供
a推荐信息，请提供建议。
That should get me started, I have tested the database locally and access is working with the FE and BE connected. Its all about how to make it user friendly to deploy. Thank you in advance, and if there is any more information you need to make a recommendation please advise.
嗨Fred，
如果您需要在MS Access实例，Azure VM或本地工作站上运行一些自定义代码或其他应用程序代码将是合适的。如果将其部署到Azure VM，则链接过程将通过Internet进行，如果需要加密该连接
，则可能需要构建站点到站点VPN，如果链接功能尚未加密。我不太了解您的解决方案以提供其他详细信息，但在Azure VM中设置此操作是最佳方法。
If you need to run some custom code or additional application code alongside an MS Access instance, an Azure VM or an on-premise workstation will be suitable. If you deploy this to an Azure VM, the linking process will go over the internet, and if that connectivity needs to be encrypted, you might need to build a Site-to-Site VPN if the linking functionality is not already encrypted. I don't know enough about your solution to provide additional details but setting up this in an Azure VM is the best course of action.
对于问题＃3，VM可以通过ARM模板部署，可以手动启动，并在某种程度上实现自动化。
As for question #3, a VM can be deployed via ARM templates that can be initiated manually and is somewhat automated.