When using VBA to access data in ODBC compliant databases, you can choose from DAO or ADO. To use either technique, you'll need to understand the object model for the appropriate technology. The ADO object model isn't overly complicated, but understanding the details of all the various ADO objects will help ensure that you use the proper object for the designated task.
This appendix lists all of the major objects needed when using ADO to access data within VBA. For each of the major objects, properties, methods, events, and associated collections are provided. Keep this appendix handy when programming ADO and refer to it when you have questions about the specific property, method, or event to use in your code.