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

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 ...