有关从.NET / C ++开发人员访问的问题 [英] Questions about Access from a .NET/C++ developer
问题描述
我是一名.NET / C ++开发人员，他应该与Access合作。
除了数据库部分我不太了解它。
问题：
* 1 *
我正在寻找能够迅速提高速度的INTENSIVE书籍。
我喜欢带书籍实践练习，还有测试题（如
证书）
* 2 *
关于Access适合的地方的一些解释在大图中 -
你通常应该使用Access以及你在哪里
应该使用别的东西。 （我正在考虑GUI部分）
* 3 *
是否有任何有趣的技术我应该看一下
访问
（.NET，脚本，开源......）
我认为它通常用VBA编写脚本 - 我可以使用Python吗？
* 4 *
我应该使用内置的数据库还是SQL Server？
（不要认为性能是一个问题）
* 5 *
我应该注意哪些新的开发项目？
* 6 *
我可以使用的免费现有解决方案的良好来源。
谢谢
Olav
I am a .NET/C++ developer who is supposed to do some work with Access.
I do not know much about it except for the DB part.
Questions:
*1*
I am looking for INTENSIVE books to get quickly up to speed.
I like books with practical exercises, and also with test questions (like
cert books)
*2*
Some explanation about where Access fits in the big picture -
what you typically should use Access for and where you
should use something else. (I am thinking of the GUI part)
*3*
Are there any interesting technologies I should look at in connection with
Access
(.NET, Scripting, Open Source...)
I think its usually scripted with VBA - Can I use Python instead?
*4*
Should I use the built in DB or SQL Server?
(Don''t think performance is an issue)
*5*
Any newer developments I should be aware of?
*6*
Good sources of free existing solutions I can work from.
Thanks
Olav
推荐答案
" Olav.NET" < 01 ****** @ hotmail.com>在消息中写道
news：41 ********************* @ news.skynet.be ...
"Olav.NET" <Ol******@hotmail.com> wrote in message
news:41*********************@news.skynet.be...
* 2 *
关于Access在大局中的适用范围的一些解释 -
你通常应该使用Access以及你应该使用其他东西的地方。 （我正在考虑GUI部分）
ms-access是一个RAD数据库前端开发工具。 （RAD = Rapid
应用程序开发）。
这意味着ms-access用于将CRUD表单设置为
$ b的数据库$ b你的选择（CRUD =创建，读取，更新，数据）。
因此，ms-access实际上不是一个数据库，而只是一个前端工具来创建
表单和数据库引擎的接口。
例如，你不能用sql server创建表单和接口，或者
Oracle，或者Mysql。
但是，你可以使用ms-access作为开发表单的工具和一个
应用程序来使用sql server，或Oracle，或Mysql，或JET等。
因此，ms-access是一个工具，可以让你的界面，并构建一个UI来b / b
编辑数据。在这方面，在VB或VB.net之类的东西中，使用相当于3美元或更多的工作量就可以了。因此，ms-access中的项目
*2*
Some explanation about where Access fits in the big picture -
what you typically should use Access for and where you
should use something else. (I am thinking of the GUI part)
ms-access is a RAD database front end development tool. (RAD = Rapid
Application Development).
This means that ms-access is designed for making CRUD forms to a database of
your choice (CRUD = Create, Read, Update , Data).
So, ms-access is not really a database, but only a front end tool to create
forms and a interface to a database engine.
For example, you can''t create forms and a interface with sql server, or
Oracle, or Mysql.
However, you can use ms-access as a tool to development forms and an
application to work with sql server, or Oracle, or Mysql, or JET etc.
So, ms-access is a tool that lets your interface, and build a UI to
edit data. In this regards, it is a good 3 or more times less work to do the
equivalent in something like VB, or VB.net. So, a project in ms-access that
cost
8000将花费你大约
8000 will cost you about
25,000或更多来开发在vb.net中。 （有些
用户评价时间因素较大......但是在VB.net中开发CRUD应用程序的成本要低得多几倍）。
例如，以下网格屏幕截图和能够编辑数据
可以完成大约1/10的编码和设置量
传统环境：
http://www.members.shaw.ca/AlbertKal...icles/Grid.htm
通常，大多数使用ms-access编写的应用程序都使用JET数据引擎。
JET是基于文件的数据库引擎。 （你可以使用那个引擎，或选择一个基于服务器的基于服务器的系统来与ms-access一样使用sql server）。
所以，重要的是意识到ms-access是一个像VB
等开发工具，并不是一个数据库。您使用ms-access编写业务应用程序，
和
选择您希望ms-access使用的数据引擎。如上所述，对于
一般业务应用程序是CURD，那么ms-access至少是开发应用程序的成本
然后是VB，或一般的。类型
开发环境。
* 3 *
有什么有趣的技术我应该看一下
Access
（。 NET，脚本，开源...）
我认为它通常用VBA编写脚本 - 我可以使用Python吗？
.NET
至于.net，ms-access不能用于编写Web服务，但SOAP
为ms添加访问权限可用，这肯定会让您在使用ms-access创建的应用程序中使用
Web服务。
开源
你当然可以使用ms-access作为MySql的前端。并且，与市场上任何其他RAD数据库工具相比，LONG SHOT可能会为ms-access应用程序发布更多源代码，而不是
。
我认为它通常用VBA编写
是的，但脚本是一个糟糕的选择。 ms访问的VBA = VB6。 （同样使用
编译器）。这意味着你有与VB6相同的语法，甚至可以使用ms-access创建和使用类对象。然而，使得ms-access
与VB6如此不同的原因是形式（对象）模型非常不同
来自
VB6（和，因为很多事情发生在表格周围..然后ms-access是
不同于VB6 ..但这主要是由于表格模型!!）。
ms-access中的表单和对象模型有一个FAR更高的学习曲线
然后是VB6，所以要准备花时间学习这个对象模型（如果
，你不会，那么你就不会意识到通过VB和vb.net这样的产品提高了生产力。
* 4 *
我应该使用内置的数据库还是SQL Server？
（不要认为性能是个问题）
这个选择取决于很多因素。如果你有一个高用户负载，那么sql server可能是内置（JET）
引擎的更好选择。您可以继续使用ms-access，但数据将因此在服务器上。这里的答案实际上取决于很多因素。如果你只有4个或6个用户，以及一个标准的
办公网络，以及100,000个记录范围内的小桌子，那么JET就更适合这份工作了。
* 5 *
我应该注意哪些新的发展？
好吧，与VB6不同，ms-access继续升级，我们继续获得新版本（每个新版本的办公室发布）。因此，例如我们现在已经在ms-access中内置了XML支持。并且，只需要主题控件。
* 6 *
我可以使用的免费现有解决方案的良好来源。
25,000 or more to develop in vb.net. (some
users rate the time factor larger...but it is at LEAST several times more
costly to development a CRUD application in VB.net).
For example, the following screen shots of grids and being able to edit data
can be done with about 1/10 the amount of coding and setup you have in
traditional environments:
http://www.members.shaw.ca/AlbertKal...icles/Grid.htm
Typically, most applications written in ms-access use the JET data engine.
JET is the file based database engine. (you can use that engine, or choose a
server based system to use with ms-access like sql server).
So, it is important to realize that ms-access is a development tool like VB
etc, and is not a database. You write business applications in ms-access,
and
choose a data engine that you want ms-access to work with. As mentioned, for
general business applications that are CURD, then ms-access is at least 1/3
the
cost of developing applications then that of VB, or "general" type
development environments.
*3*
Are there any interesting technologies I should look at in connection with
Access
(.NET, Scripting, Open Source...)
I think its usually scripted with VBA - Can I use Python instead? .NET
As for .net, ms-access cannot be used to write web services, but the SOAP
add in for ms-access is available,and this most certainly lets you consume
web services in your applications that you create with ms-access.
Open Source
You can certainly use ms-access as front end to MySql. And, there is likely
more source code posted for ms-access applications by a LONG SHOT as
compared to any other RAD database tool in the market place.
I think its usually scripted with VBA
Yes, but script is a poor choice of words. VBA for ms-access = VB6. (same
compiler is used). That means you have the same syntax as VB6, and can even
create and use class objects with ms-access. However, what makes ms-access
so different then VB6 is that the forms (object) model is VERY different
from
VB6 (and, since a lot of things happen around forms..then ms-access is
different then VB6..but this mostly only due to the forms model!!).
The forms and objects model in ms-access has a FAR HIGHER learning curve
then does VB6, so be prepared to spend time learning this object model (if
you don''t, then you will not realize the increased productivity that
ms-access has over products like VB, and vb.net).
*4*
Should I use the built in DB or SQL Server?
(Don''t think performance is an issue)
This choice is going to depending on many factors. If you have a high user
load, then sql server might be a better choice then the built in (JET)
engine. You can continue to use ms-access, but the data will thus
be on the server. The answer here is really going to depend on
many factors. If you only got 4, or 6 users, and a standard
office network, and small tables in the 100,000 record range,
then JET is more then adequate for the job.
*5*
Any newer developments I should be aware of?
Well, unlike VB6, ms-access continues to be upgraded, and we continue to get
new versions (released with each new version of office). So, for example we
now have XML support built into ms-access. And, just got themed controls.
*6*
Good sources of free existing solutions I can work from.
我能想到的最佳起点是：
http://www.mvps.org/access/
-
Albert D. Kallal（访问MVP）
加拿大艾伯塔省埃德蒙顿
pl ********* ********@msn.com
http://www.members.shaw.ca/AlbertKallal
The best starting point I can think of is here:
http://www.mvps.org/access/
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com
http://www.members.shaw.ca/AlbertKallal
这篇关于有关从.NET / C ++开发人员访问的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
