April 2007
Beginner
573 pages
12h 41m
English
Content preview from Beginning Access™ 2007 VBA
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,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
5.2. Using ADODB to Work with Data
In this section, you will explore the ADO object model and how to use the objects therein to work with data in underlying databases.
5.2.1. The ADO Object Model
Figure 5-1 provides an overview of the ADO object model. At the highest level of the object model, several collections exist: Connection, Recordset, Command, Record, and Stream.
Figure 5.1. Figure 5-1
The ADO object library is sometimes referred to as the ADODB library. In order to use the features of ADO, you must have a reference to one of the ADO library versions in your project. You can add a reference to an ADO library by selecting Tools 
References from Visual Basic Editor and choosing a library from the list. Figure 5-2 shows an example with a reference set to version ADO version 2.7.
Several versions of ADO may exist on your computer, such as 2.1, 2.5, 2.7, and 2.8. The version you choose for your project depends on the version of Access that others in your organization are using. If everyone is using Access 2007 or higher, you should use version 2.8. If everyone is using Access 2002 or higher, you should use version 2.7. If some people are using Access 2000, then you may want to use ADO version 2.5. If some are using Access 97, you may want to use ADO version 2.1.
The examples ...
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.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.