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.