访问还是Visual Studio？ [英] Access or Visual Studio?

问题描述

我有点困惑......我什么时候会使用MS Access和Visual Basic编写数据库

应用程序以及何时（以及为什么）我将

而不是使用Visual Studio .Net编写它？


访问？


VS.net的优势在于并非每个用户都需要Access，对吧？并且

也可以消除Access版本问题。我想。


我已经在Access和asp.net中完成了这些工作/>

谢谢！

Hi, I''m a bit confused ... when would I rather write an database
application using MS Access and Visual Basic and when (and why) would I
rather write it using Visual Studio .Net?

Is it as easy in Visual Studio to create reports and labels as it''s in
Access?`

The advantage of VS.net is that not every user needs Access, right? And
that would eliminate the Access version problem as well I guess.

I''ve both done stuff in Access as well as asp.net

Thanks!

推荐答案

" Jerome" <无**** @ nospam.com>在消息中写道

新闻：ey ************** @ TK2MSFTNGP09.phx.gbl ...

"Jerome" <no****@nospam.com> wrote in message
news:ey**************@TK2MSFTNGP09.phx.gbl...

我是'麻烦有点困惑...我什么时候会使用MS Access和Visual Basic编写数据库应用程序？何时（以及为什么）我会使用Visual Studio .Net来编写它？
<在Visual Studio中创建报表和标签是否像在Access中一样容易？

VS.net的优势在于并非每个用户都需要Access，对？而且我想这也会消除Access版本问题。

我已经在Access以及asp.net中完成了任务

谢谢！

Hi, I''m a bit confused ... when would I rather write an database
application using MS Access and Visual Basic and when (and why) would I
rather write it using Visual Studio .Net?

Is it as easy in Visual Studio to create reports and labels as it''s in
Access?`

The advantage of VS.net is that not every user needs Access, right? And
that would eliminate the Access version problem as well I guess.

I''ve both done stuff in Access as well as asp.net

Thanks!

Access是一个非常优越的数据库应用程序开发平台：

开发成本低得多，而且它具有出色的以数据库为中心

功能包括链接子表单和连续表单。使用

除了Access之外的其他任何东西构建数据库应用程序的唯一原因是，如果你想在互联网上使用它b / b
，这是你不能做的事情使用Access。

即使您拥有庞大的用户群或要求安全/弹性

的要求，仍然最好使用Access，链接到服务器数据库

引擎，例如SQL Server。


如果您购买Office Developer Edition，或者微软称之为

这些天，您可以免费分发Access的运行时版本，以便

您不需要为所有用户购买Access。

Access is a vastly superior development platform for database applications:
the cost of development is far lower, and it has wonderful database-centric
features like linked subforms and continuous forms. The only reason to use
anything other than Access to build a database application is if you want it
on the internet, which is something that you just can''t do with Access.
Even if you have a large user population or demanding security/resilience
requirements, it''s still best to use Access, linked to a sever database
engine such as SQL Server.

If you buy the Office Developer Edition, or whatever Microsoft is calling it
these days, you can freely distribute a run-time version of Access so that
you don''t need to buy Access for all your users.

访问应该用作不需要大量数据的可移植数据库。

SQL Server（Oracle等）应该用于可能使用大量数据的根数据库。 br />

VS.NET不是数据库。它可以连接到任何ODBC数据库的实例，我相信某些（可能是所有）版本的

VS.NET附带了MSDE版本的SQL Server。这是一个桌面引擎，允许开发人员开发数据库代码，而不必购买完整版本的软件。


如果您计划使用数据库一个网站，如果没有大量的数据，Access是可行的，高性能

在压力环境中是不可预期的，不需要安全角色以及T-SQL，DTC和Extended的好处存储过程

不是必需的。


否则，考虑购买更强大的数据库服务器。


For目前，我相信你可以使用VS.NET附带的MSDE版本进行开发。


希望它有所帮助。

-

Dave Sexton
dave @ www..jwaonline..com

------------------------------------------------- ----------------------

" Jerome" <无**** @ nospam.com>在留言新闻中写道：ey ************** @ TK2MSFTNGP09.phx.gbl ...

Access should be used as a portible database where large amounts of data is not expected.
SQL Server (Oracle, etc.) should be used for rooted databases where potentially large amounts of data will be used.

VS.NET is not a database. It can connect to an instance of any ODBC database, and I believe that some (maybe all) versions of
VS.NET ship with MSDE version of SQL Server. This is a desktop engine which allows developers to develop database code without
having to purchase full versions of the software.

If your planning on using the database for a website, Access is viable if there will not be large amounts of data, high performance
is not expected in a stressful environment, security roles are not required and the benefits of T-SQL, DTC and Extended Stored Procs
are not required.

Otherwise, think about purchasing a more robust database server.

For the time being, I believe you can use the MSDE version that shipped with VS.NET for development purposes.

Hope it helps.
--
Dave Sexton
dave@www..jwaonline..com
-----------------------------------------------------------------------
"Jerome" <no****@nospam.com> wrote in message news:ey**************@TK2MSFTNGP09.phx.gbl...

我有点困惑......什么时候会我宁愿使用MS Access和Visual Basic编写一个数据库
应用程序，何时（以及为什么）我会使用Visual Studio .Net来编写它？

它是否容易Visual Studio在
Access中创建报表和标签？

VS.net的优势在于并非每个用户都需要Access，对吧？而且我想这也会消除Access版本问题。

我已经在Access以及asp.net中完成了任务

谢谢！

Hi, I''m a bit confused ... when would I rather write an database
application using MS Access and Visual Basic and when (and why) would I
rather write it using Visual Studio .Net?

Is it as easy in Visual Studio to create reports and labels as it''s in
Access?`

The advantage of VS.net is that not every user needs Access, right? And
that would eliminate the Access version problem as well I guess.

I''ve both done stuff in Access as well as asp.net

Thanks!

Brian，

Brian,

Access是一个非常优越的数据库开发平台
应用程序：
开发成本低得多，并且具有奇妙的以数据库为中心的功能，如链接子表单和连续表单。使用
除了Access之外的其他任何东西构建数据库应用程序的唯一原因是，如果你想在互联网上使用
它就是你不能做的事情使用Access。
即使您拥有大量用户群或要求安全性/弹性要求，它仍然最好使用Access，链接到服务器数据库引擎，如SQL Server 。

Access is a vastly superior development platform for database
applications:
the cost of development is far lower, and it has wonderful
database-centric
features like linked subforms and continuous forms. The only reason to
use
anything other than Access to build a database application is if you want
it
on the internet, which is something that you just can''t do with Access.
Even if you have a large user population or demanding security/resilience
requirements, it''s still best to use Access, linked to a sever database
engine such as SQL Server.

您的团队建立同步应用程序的规模有多大？


以及如何实现可重用性？


Cor

How large is your team to build simultanisly applications with?

And how you have reusability implemented with that?

Cor

这篇关于访问还是Visual Studio？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！