Chapter Summary

This chapter covered quite a bit of advanced ADO material you will find useful in developing professional applications in Microsoft Access.

You started by creating your own recordset from scratch and using it for storing non-relational data. Next, you learned how to disconnect a recordset from a database and work with it offline. You also learned that a recordset can be saved to a disk file and later reopened without an active connection to the database. Next, you discovered how you can use the Clone method of the Recordset object to create a recordset that is a copy of another recordset. Finally, you familiarized yourself with the concepts of data shaping and learned statements that make it possible to create impressive, hierarchical views of your data. You also learned how transactions are used to ensure that certain database operations are always performed as a single unit.

In the next chapter, you will learn how to use ADO to handle database security.

0 0

Post a comment