终端服务和VB.Net解决方案？ [英] Terminal services and VB.Net Solution?

问题描述

我为我的客户创建了一个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.com写信息

新闻：D6 ******************* *************** @ microsof t.com ...

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.microsoft.comwrote in message
news:D6**********************************@microsof t.com...

感谢您的投入，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.

这篇关于终端服务和VB.Net解决方案？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！