In this chapter, you will learn how to write code that uses ActiveX Data Objects (ADO) to connect to a data source, retrieve and manipulate data, and disconnect from a data source. You will also learn how to build and manage disconnected recordsets.

Objectives

After completing this chapter, you will be able to:

• List the major components of the ADO object model.
  
  
• Explain how to handle errors using ADO.
  
  
• Connect to a data source using ADO.
  
  
• Use an ADO Recordset object to retrieve and manipulate data.
  
  
• Describe and use a disconnected recordset.
  
  
• Use an ADO Recordset object to store non-database data.