Skip to Main Content
Microsoft® Access® 2010 Programmer's Reference
book

Microsoft® Access® 2010 Programmer's Reference

by Teresa Hennig, Rob Cooper, Geoffrey L. Griffith, Jerry Dennison
August 2010
Intermediate to advanced content levelIntermediate to advanced
1272 pages
32h 43m
English
Wrox
Content preview from Microsoft® Access® 2010 Programmer's Reference

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.

Note

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

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Access™ 2007 VBA Programmer's Reference

Access™ 2007 VBA Programmer's Reference

Teresa Hennig, Rob Cooper, Geoffrey Griffith, Armen Stein
Excel® 2007 VBA Programmer's Reference

Excel® 2007 VBA Programmer's Reference

John Green, Stephen Bullen, Rob Bovey, Michael Alexander
Professional Access 2013 Programming

Professional Access 2013 Programming

Teresa Hennig, Ben Clothier, George Hepworth, Dagi Yudovich

Publisher Resources

ISBN: 9780470591666Purchase book