O'Reilly logo

F. Scott Barker's Microsoft® Access 2000 Power Programming by F. Scott Barker

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

USING DATA ACCESS OBJECTS VERSUS ACTIVEX DATA OBJECTS

Although the choice of using DAO versus ADO is fast becoming a moot point because Microsoft is aiming us that way, it's a very real one for Access 2000.

As mentioned at the beginning of this chapter, DAO has been around for quite a few versions of Access and has pretty well been the standard for database manipulation with Jet from VB and all Office products.

Then along comes ADO. ADO has come on the scene because DAO was written and optimized mainly for Jet. The idea is that with the way the world is going with the Internet and multiple data sources, the belief was that an easier, more generic way to access that data was needed—hence, ADO.

Note

In Access 2000, not all functionality is provided ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required