ADO / DAO [英] ADO/DAO

问题描述

我已经离开Access一段时间了，现在正在回来。


当我离开时，ADO已经到达现场，但大多数人仍然是

使用DAO。


有人可以指出一些行业声明和意见作为

，你今天应该用于新的Access开发，和
关于同一主题的一些更多关于Usenet的论点？


提前致谢。

解决方案

>有人能指出我的一些行业声明和意见，作为

，你今天应该用于新的Access开发，还有一些关于同一主题的更多关于Usenet的论点吗？

AFAIK，ADO在某些自动化功能方面表现不佳。我在我的mdb中使用了很多

自动化，并且在克隆的

Recordset中使用书签也有问题（可能是我的错误），所以我选择了DAO。但ADO是另外选择的

访问方法。

DAO是Jet数据库引擎的自然语言，以及
的语言/>
如果您使用Jet（默认情况下使用Access安装时），请选择。


DAO和Jet是处于维护模式，这只是错误影响其他产品的产品预计将被修复（尽管事实上，微软已经做了一些超出他们的政策规定的修正和增强措施，因为他们已经有了

一直处于维护模式。


有很多关于ADO的大肆宣传，有些人心存，当时

它出来了。但在Access中使用并仍然使用的经典ADO也是一个

_dead-end_。后继版本已经发布，ADO.NET只共享

部分名称，并建立在不同的对象模型上。


来自kno的最新信息可敬的微软内部人员

，至少一般，使用MDB-Jet-ODBC-MS SQL甚至更好用
服务器（可以是任何ODBC-兼容的服务器数据库，而不是使用

访问项目，ADP，ADODB，MS SQL Server（据我所知，这只能与
一起使用） Microsoft SQL Server，而不是任何其他服务器数据库。


因此，我必须强烈地区别于deko的建议。


Larry Linson

Microsoft Access MVP

" JB" < GY ********** @ jmjservices.com>在消息中写道

新闻：1O ******************* @ fe2.columbus.rr.com ...

我已经离开Access一段时间了，现在正在回来。

当我离开时，ADO已经到达现场，但大多数人仍然使用DAO。

有人能指出我今天应该用于新的Access开发的一些行业声明和意见，还有一些关于同一主题的更多关于Usenet的论点吗？ br />
提前致谢。

>有大量的炒作。关于ADO，有些人心存，

当

出来时。但是经典ADO在Access中使用和仍然使用的还是一个
_dead-end_。后继版本已经发布，ADO.NET，它只是名称的一部分，并且是基于不同的对象模型构建的。

Perhpas what I 一直在阅读是炒作。这对我来说没关系，因为我已经对DAO感到很满意了。我以为ADO会取代DAO？

I''ve been away from Access for awhile and am now returning.

When I left, ADO had arrived on the scene, but most people were still
using DAO.

Could someone point me towards some industry statements and opinions as
to which you should be using for new Access development today, and to
some more enlghtened Usenet arguments about the same topic?

Thanks in advance.

解决方案

> Could someone point me towards some industry statements and opinions as

to which you should be using for new Access development today, and to
some more enlghtened Usenet arguments about the same topic?

AFAIK, ADO doesn''t play well with some Automation functions. I use a lot of
Automation in my mdb and also had trouble with using bookmarks in a cloned
Recordset (may have been my error), so I went with DAO. But ADO is the
access method of choice otherwise.

DAO is the natural language of the Jet database engine, and the language of
choice if you are using Jet (the default when you use Access as installed).

DAO and Jet are "in maintenance mode", that is only bugs that affect other
products are expected to be fixed (though Microsoft has, in fact, done some
corrections and enhancements beyond what their policy states since they have
been in maintenance mode.

There was a good deal of "hype" about ADO, which some "took to heart", when
it came out. But the "classic ADO" used and still used in Access is also a
_dead-end_. The successor is already released, ADO.NET, which shares only
part of the name, and is built on a different object model.

There has been recent information from knowledgeable Microsoft insiders
that, at least "in general", it is even better to use MDB-Jet-ODBC-MS SQL
Server (could be any ODBC-compliant server DB, though) than to use the
Access Project, ADP, ADODB, MS SQL Server (and, far as I know, this can ONLY
be used with Microsoft SQL Server, not any other server database).

Thus, I would have to differ, strongly, with deko''s advice.

Larry Linson
Microsoft Access MVP
"JB" <gy**********@jmjservices.com> wrote in message
news:1O*******************@fe2.columbus.rr.com...

I''ve been away from Access for awhile and am now returning.

When I left, ADO had arrived on the scene, but most people were still
using DAO.

Could someone point me towards some industry statements and opinions as
to which you should be using for new Access development today, and to
some more enlghtened Usenet arguments about the same topic?

Thanks in advance.

> There was a good deal of "hype" about ADO, which some "took to heart",
when

it came out. But the "classic ADO" used and still used in Access is also a
_dead-end_. The successor is already released, ADO.NET, which shares only
part of the name, and is built on a different object model.

Perhpas what I''ve been reading is hype. That''s okay with me since I''ve
become pretty comfortable with DAO. I thought ADO was going to replace DAO?

这篇关于ADO / DAO的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！