终端服务和VB.Net解决方案？

本文介绍了终端服务和VB.Net解决方案？的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我为我的客户创建了一个Access 2007应用程序。该应用程序是由服务器上的三名员工共享的。它维护一份联系清单，包括 财务数据和社会安全号码。只有办公室经理 从这个客户端数据生成Access报告。 现在他们想与远程员工共享这个Access应用程序 办公室。他们希望最多有30名员工在本地和远程办公室编辑客户 列表。所以，我正在寻找一个允许增长的解决方案 - 这样更多的用户可以安全地编辑他们的 联系人列表 - 无论是本地还是远程。 br /> 您认为以下是一个很好的解决方案吗？ 1）通过在Visual Basic中编程将Access前端转换为.Net 2008快递。然后，此前端将根据需要创建与客户端的连接 列表数据 - 获取数据或保存更改 - 然后删除 连接。 2）使用 Access upsize向导将Access 2007后端转换为SQL Server 2008 Express。 3 ）将报表保存在Access 2007中。将Access报表连接到SQL Server 2008 Express中的 客户端列表数据。只有办公室经理需要 才能生成报告。据我所知，SQL Server 2008 Express中有10个连接可用 。因此，可以牺牲一个席位来生成 报告。 4）聘请网络顾问...... * *在他们的本地办公室购买并设置第二台服务器（使用RAID for 镜像） **在新服务器上安装Windows Server 2008 **设置20个终端服务席位，以便在新服务器上进行远程访问。 **在新服务器上安装SQL Server 2008 Express **每日设置新服务器的备份。 **宽带互联网连接至少应该是1兆字节或更好的新服务器所在的本地办公室。 以上所有软件是否在.Net Framework 3.5下顺利运行？如果有，是否有任何软件，每个终端服务 安装座位需要降低？ 我将非常感谢听到任何建议。 />

I created an Access 2007 application for my customer. The application is shared by three employees on a server. It maintains a contact list including financial data and social security numbers. Only the office manager generates reports in Access from this client data. Now they want to share this Access application with employees at a remote office. They expect to have a maximum of 30 employees editing the client list in both the local and remote offices. So, I''m looking for a solution that will allow for growth -- so that more users can securely edit their contact list - both locally and remotely. Do you think the following is a good solution? 1) Convert the Access front-end to .Net by programming it in Visual Basic 2008 Express. This front end will then create a connection to the client list data as needed -- get the data or save changes -- then drop the connection. 2) Convert the Access 2007 back-end to SQL Server 2008 Express by using the Access upsize wizard. 3) Keep the reports in Access 2007. Connect the Access reports to the client list data in SQL Server 2008 Express. Only the office manager needs to generate reports. I understand that there are 10 connections available in SQL Server 2008 Express. So, one seat could be sacrificed for generating reports. 4) Hire a networking consultant to... ** Buy and set up a second server in their local office (with RAID for mirroring) ** Install Windows Server 2008 on the new server ** Set up 20 terminal services seats for remote access on the new server. ** Install SQL Server 2008 Express on the new server ** Set up daily backups of the new server. ** Broadband internet connection should be at least 1 meg up or better at local office where the new server will be located. Does all of the above software operate smoothly together under .Net Framework 3.5 ? If yes, is there any software that each terminal services installation seat needs to drop on? I will be very grateful to hear any recommendations.

推荐答案

Dweeberella写道： Dweeberella wrote: 我为我的客户创建了一个Access 2007应用程序。 应用程序由服务器上的三名员工共享。它维护一个 的联系人列表，包括财务数据和社会安全号码。 只有办公室经理在Access中生成来自该客户的报告 数据。 现在，他们希望与 远程办公室的员工共享此Access应用程序。他们希望最多有30名员工在本地和远程办公室的客户名单上编辑 。所以，我是寻找一个可以增长的解决方案 - 这样更多的用户可以安全地编辑他们的联系人列表 - 无论是本地还是 远程。 I created an Access 2007 application for my customer. The application is shared by three employees on a server. It maintains a contact list including financial data and social security numbers. Only the office manager generates reports in Access from this client data. Now they want to share this Access application with employees at a remote office. They expect to have a maximum of 30 employees editing the client list in both the local and remote offices. So, I''m looking for a solution that will allow for growth -- so that more users can securely edit their contact list - both locally and remotely.

您是否考虑过将其改为ASP.NET应用程序？就这样 你不需要20个终端服务座位，甚至是新服务器，如果你已经在某个地方运行IIS的网络服务器了。 Andrew

Have you considered making it into an ASP.NET application instead? That way you wouldn''t need 20 terminal services seats, or even a new server, if you have a web server running IIS somewhere already. Andrew

感谢您的投入，Andrew。实际上，我们正在考虑使用 ASP.Net。但我与网站主人的老板谈过，他坚持认为在线托管数据是一种安全风险。他说在线托管应该只用于你想与全世界分享的数据。这个应用程序的目的是维护社会安全号码和其他客户财务数据列表。 因此，安全性是一个大问题。 Thank you for your input, Andrew. Actually, we were thinking of going with ASP.Net. But I talked to the owner of a web host who was adamant that hosting data online is a security risk. He said that hosting online should only be used for data that you want to share with the world. The purpose of this application is to maintain a list of social security numbers and other client financial data. So, security is a big concern.

你认为你目前的情况更省钱吗？ 可能这就是为什么大多数银行，网上商店等都没有使用它。 只是我的想法阅读你的消息 Cor " Dweeberella" < Dw ********* @ discussion.microsoft写信息 新闻：D6 ******************* *************** @ microsof t ... And you think your current situation is more save? Probably that is why most banks, on line shops etc are not using it. Just my thought reading your message Cor "Dweeberella" <Dw*********@discussions.microsoftwrote in message news:D6**********************************@microsof t... 感谢您的投入，Andrew。实际上，我们打算用 ASP.Net来支付。但我与网站主人的老板谈过，他坚持认为在线托管数据是一种安全风险。他说在线托管 应该只用于你想与全世界分享的数据。目的 此应用程序用于维护社会安全号码列表和 其他 客户财务数据。因此，安全性是一个大问题。 Thank you for your input, Andrew. Actually, we were thinking of going with ASP.Net. But I talked to the owner of a web host who was adamant that hosting data online is a security risk. He said that hosting online should only be used for data that you want to share with the world. The purpose of this application is to maintain a list of social security numbers and other client financial data. So, security is a big concern.