Special Edition Using Microsoft® Access 2000

Chapter 27. Understanding Universal Data Access, OLE DB, and ADO

In this chapter

• Gaining a Perspective on Microsoft's New Data Access Components

• Interfacing with a Wide Range of Data Sources

• Creating ADODB.Recordsets

• Exploring Top-Level ADO Properties, Methods, and Events

• Working with the ADODB.Connection Object

• Using the ADODB.Command Object

• Understanding the ADODB.Recordset Object

• Troubleshooting

• In the Real World—Struggling with ADO

Gaining a Perspective on Microsoft's New Data Access Components

Access 2000 represents the pivot point of Microsoft's strategy for data access. Under the umbrella of "Universal Data Access," Microsoft wants all Office users, not just Access developers, to abandon Data Access Objects (DAO), ODBCDirect, and the Open Database ...