将Access 97应用程序升级到dotNet [英] Upgrading Access 97 application to dotNet
问题描述
您好。不确定这是正确的地方，但是这里有。
我有一个基于access97和VB6的应用程序，我需要
升级。它必须在Win2k网络上处理多达20个并发用户
（明年将升级到XP），它与外界的
无关，但通常在那里它不超过2.它有大约150张表，其中包含复杂的验证规则和大量的b
计算量。我想在VB net或C＃中用一个合适的现代数据库重写它。所以我到目前为止我已经有了3周的
..Net世界的经验。
我不允许运行任何形式的中央数据库服务器，但数据
表必须（？）保存在网络服务器上以提供多用户
的能力。还必须可以将应用程序和它的数据库转移到独立的笔记本电脑上，以便在其他地方使用。
我可以以任何形式使用SQL Server因为这似乎是
VS2005的最佳匹配，还是我必须继续使用Access？
关于最佳方法的任何建议都是非常欢迎。
提前致谢。
Hi. Not sure that this is the right place to ask but here goes.
I have an application based on access97 and VB6 which I need to
upgrade. It has to handle up to 20 concurrent users on a Win2k network
( to be upgraded to XP next year) which has no connection to the
outside world, but normally there are no more than 2. It has
approximately 150 tables with complicated validation rules and a large
amount of calculation. I want to rewrite it in VB net or C# with a
suitable modern database. So I far I have 3 weeks experience of the
..Net world.
I am not permitted to run any form of central database server, but data
tables must (?) be held on the network server to provide the multi user
capability. It must also be possible to transfer the application and
its database to a standalone laptop for use in other locations.
Can I use SQL Server in any form as this seems to be the best match for
VS2005 or do I have to continue to use Access?
Any advice on the best way to proceed would be most welcome.
Thanks in advance.
推荐答案
你当然可以使用SQL Server对于您的数据存储，但它可能会与您的要求没有中央数据库服务器的形式冲突。使用。
SQL Server是一个数据库服务器，顾名思义。也许你的意思是
不会有专门用于管理
数据库的机器设置。 SQL Server可以安装在任何工作站上，并且可以向其他用户提供
。听起来你的数据交互需求很简单，所以
这应该可行。
Access SQL和SQL Server SQL之间存在一些语法差异，
但你可能会很快学会并纠正它们。还有，那么
是一个涉及SQL Server数据库的更多管理;这不是
只是一个像Access这样的文件。但是，还是要感谢你不要考虑使用Oracle（20MB最小客户端安装数百个文件.Boo.Hiss。）
VB2005包括升级向导。这将把您的VB6程序转换为
VB2005。它并没有完成一项完整的工作，有时甚至不是一份出色的工作。
但它会让你从头开始编写它。
我有一本书涉及在VB2005中开发数据库应用程序
（请参阅下面的签名）。但如果您的重点是数据库方面，那么您可能还想考虑Bill Vaughn的许多好书（Hitchhiker
指南）。
-----
Tim Patrick - www.timaki.com
从头到尾Visual Basic 2005
You can certainly use SQL Server for your data storage, but it may conflict
with your requirement that no "form of central database server" be used.
SQL Server is a database server, as its name implies. Perhaps you mean that
there will not be a machine set up that is solely dedicated to managing the
database. SQL Server can be installed on any workstation and made available
to other users. It sounds like your data interaction needs are simple, so
this should work.
There are some syntax differences between Access SQL and SQL Server SQL,
but you will probably learn and correct those pretty quickly. Also, there
is a little more administration involved in a SQL Server database; it''s not
just a single file like Access. But still, give thanks that you aren''t considering
Oracle (20MB minimum client-side install with hundreds of files. Boo. Hiss.)
VB2005 includes an "upgrade wizard" that will convert your VB6 program to
VB2005. It doesn''t do a complete job, and sometimes not even a great job.
But it will give you a start over writing it from scratch.
I have a book that deals with developing database applications in VB2005
(see my signature below). But if your focus is on the database side, you
may also want to consider the many good books by Bill Vaughn (the "Hitchhiker"
guides).
-----
Tim Patrick - www.timaki.com
Start-to-Finish Visual Basic 2005
嗨。不确定这是正确的地方，但是这里有。
我有一个基于access97和VB6的应用程序，我需要
升级。它必须在Win2k网络上处理多达20个并发用户
（明年将升级到XP），它与外界的
无关，但通常在那里它不超过2.它有大约150张表，其中包含复杂的验证规则和大量的b
计算量。我想在VB net或C＃中用一个合适的现代数据库重写它。所以我到目前为止我已经有了3周的
.Net世界经验。
我不允许运行任何形式的中央数据库服务器，但是/>
数据表必须（？）保存在网络服务器上以提供
多用户功能。还必须可以将
应用程序及其数据库传输到独立笔记本电脑，以便在其他
位置使用。
我可以以任何形式使用SQL Server，因为这似乎是VS2005的最佳匹配
还是我必须继续使用Access？
任何建议最好的方式是最受欢迎的。
提前致谢。
Hi. Not sure that this is the right place to ask but here goes.
I have an application based on access97 and VB6 which I need to
upgrade. It has to handle up to 20 concurrent users on a Win2k network
( to be upgraded to XP next year) which has no connection to the
outside world, but normally there are no more than 2. It has
approximately 150 tables with complicated validation rules and a large
amount of calculation. I want to rewrite it in VB net or C# with a
suitable modern database. So I far I have 3 weeks experience of the
.Net world.
I am not permitted to run any form of central database server, but
data tables must (?) be held on the network server to provide the
multi user capability. It must also be possible to transfer the
application and its database to a standalone laptop for use in other
locations.
Can I use SQL Server in any form as this seems to be the best match
for VS2005 or do I have to continue to use Access?
Any advice on the best way to proceed would be most welcome.
Thanks in advance.
感谢您的快速回复，但我的确意味着没有
服务器。使用别人工作站也不是一种选择。
中央数据存储和个人数据库引擎是强制性的。
这种灰色适合的人有很多偏执狂/>
组织。
Thanks for the prompt reply, but I really do mean that there can be no
server. Using someone elses workstation is not an option either.
Central data storage and individual database engines are mandated.
There is a very large amount of paranoia in this grey suited
organisation.
哎呀，这听起来不像技术问题。
SQL Server确实作为服务运行，而不是像Access这样的应用程序运行，或者作为OLE DB等自己程序的扩展名。
。 SQL Server Express
确实有一种模式可以让你直接访问MDF文件（类似于MDB文件）
而不是通过基于服务器的普通方法，但我不知道
是否知道该方法是否支持多个用户。我从未使用过基于文件的
方法，我认为它只适用于产品的Express版本。
VB2005继续支持访问得很好，所以您可以继续使用该数据源继续
。
-----
Tim Patrick - www.timaki.com
开始 - 完成Visual Basic 2005
Gee, this doesn''t sound like a technology issue.
SQL Server does run as a service, not as an application like Access, or as
an extension of your own program like OLE DB and the like. SQL Server Express
does have a mode that lets you access an MDF file (similar to an MDB file)
directly instead of through the normal server-based methods, but I don''t
know if that method would support multiple users. I''ve never used that file-based
method, and I think it only applies to the Express version of the product.
VB2005 continues to support Access just fine, so you''re free to continue
with that data source.
-----
Tim Patrick - www.timaki.com
Start-to-Finish Visual Basic 2005
感谢您的快速回复，但我的确意味着没有
服务器。使用别人工作站也不是一种选择。
中央数据存储和个人数据库引擎是强制性的。
这种灰色适合的人有很多偏执狂/>
组织。
Thanks for the prompt reply, but I really do mean that there can be no
server. Using someone elses workstation is not an option either.
Central data storage and individual database engines are mandated.
There is a very large amount of paranoia in this grey suited
organisation.
这篇关于将Access 97应用程序升级到dotNet的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
