Summary

This is the second of two chapters that target ADO data access issues for Access developers. The techniques presented in this chapter expand and complement those presented in Chapter 1 by examining Command objects and how to use them with Parameter objects to support user interaction at run time. Next, you were presented a set of techniques for managing inserts , updates, and deletes based on SQL statements and Command objects. Chapter 1 described and demonstrated how to insert, update, and delete table and query rows from a Recordset object. Each approach has merit. Using a Recordset object has the merit of not requiring any knowledge of the SQL language for a database. The approach presented in this chapter requires a knowledge of the SQL language for a database, but it can generate faster results especially when working with record sources that have many rows. While Chapter 1 initiated a discussion of recordsets, this chapter revisits the Recordset object to examine how it interoperates with the Record object. You also gain exposure to Stream objects, which were not covered at all in the earlier chapter.