July 1999
Intermediate to advanced
432 pages
13h 10m
English
Content preview from Access Database Design and Programming, Second Edition
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.
Installing ADO
We should mention a word about installing ADO. ADO is installed along with Office 2000, but not with Office 97.
To see if you have ADO installed on your system, first open an Access code module and then open the References dialog under the Tools menu. If you see an entry such as the one highlighted in Figure 17.1, you’re all set.
Figure 17-1. Reference to the ADO object library
If, on the other hand, you have no such listing, you might want to do
a file search of your hard disk, looking for
MSADOxx.DLL. If you don’t have the file,
then you can download the required software components from
Microsoft’s web site. At the time of this writing, the URL is
http://www.microsoft.com/data/mdac2.htm. (If
this URL is no longer valid, try searching for ADO or MDAC, which
stands for Microsoft Data Access Components.) Note that the small
version of the software kit is over 5 MB! Enjoy.
Note also that there is considerable confusion when it comes to versions of ADO, a situation that Microsoft does not seem to want to clarify. Version 2.0 refers to the following items, as reported by the type library itself (or the VBA IDE References dialog box). Note the different version numbers:
Implementation:
msado15.dllObject library name:
msado15.dllObject Library Version: 2.0
Documentation String: Microsoft ActiveX Data Objects 1.5 Library
Help File:
msado10.hlp
On the other hand, version 2.1 of ...
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.