F. Scott Barker’s Microsoft Access 2002 Power Programming

Chapter 5. Introducing ActiveX Data Objects

IN THIS CHAPTER

• Looking at ADO’s Object Models 110

• Referencing the Type Libraries 113

• Opening a Connection to a Database 115

• Creating a Recordset 116

• Working with Queries 123

• Working with Tables 127

ActiveX Data Objects (ADO) is Microsoft’s standard data-access method for most Office, Web, and Visual Basic environments. Products that ship ADO in the box include Microsoft Office 200x, Visual Studio 6.0 (including all languages in the box), and SQL Server 7.0/2000.

Note

The next version of ADO under development is ADO.NET, which will be included in Visual Studio.NET, the next version of the Microsoft tools. At the time of this writing, the .NET tools were in beta testing.

Data Access Objects (DAO), the previous ...