Chapter 12. Using ADO to Access Data
WHAT'S IN THIS CHAPTER?
Using ActiveX Data Objects (ADO) in an Access database application
Adding a reference to ADO for a VBA code project
Creating connection strings to ADO data sources
Setting cursor types
Using ADO transactions
Adding/Modifying/Deleting Data in an ADO data source
Executing SQL statements against an ADO data source
Creating and manipulating ADO Recordset objects
Creating and executing ADO events
Working with data source schema using ADOX
ActiveX Data Objects (ADO) was created by Microsoft to provide a standardized Object Model for connecting to a wide variety of external data sources, as part of the Universal Data Access (UDA) plan. UDA refers to a plan in which there is a single, standardized object that can be implemented to retrieve data from any type of data source. Specifically, the "Object Linking and Embedding Databases" (OLE DB) is the UDA interface that enables providers to implement data access to their data source. ADO is the API that sits on top of OLE DB, providing the code functionality. Essentially, ADO is a code library that allows developers to work with data from all different types of data sources.
Appendix C provides a detailed description of the ADO Object Model and should be used in conjunction with this chapter.
INTRODUCTION TO ADO IN ACCESS
When you use Access 2010 to create a new database, by default, Access uses the ACE OLE DB provider for the connection to the
CurrentProject. That means any functionality that ...