What We Learned
-
Programming ADO is very similar to DAO
-
We program to ADO, but it is the OLE DB provider that does the real work of taking the ADO commands and translating them to work with the data source
-
The Connection Wizard can be used to seamlessly create the connection string
-
Once we are connected to an OLE DB data source, we can access data almost exactly like DAO
-
Declaring an object variable implicitly or explicitly requires us to handle the variable differently when bringing it to life
-
Transactions are not only useful when working with several recordsets, but can speed up everyday data access tasks
And now we will move on to another cool use of ADO – building our own bound ADO ActiveX control.
© 1998 by Wrox Press. All rights reserved.