Access™ 2007 VBA Programmer's Reference

7.12. Summary

in this chapter, you learned about the ADO object model, which included both the ADODB library, for manipulating data, and the ADOX library, for manipulating database schema.

By now you have a fairly good working knowledge of creating and using ADO connections and transactions, and can create and execute queries using both Connection and Command objects. You should be able to confidently create and filter ADO recordsets, navigate your way around their rows, find specific records, and edit their data.

You also explored persistent and disconnected recordsets, and examined the use of multiple SELECT clauses, shaped queries, and schema recordsets. You should be fairly confident of your understanding of ADO events.

In addition, you took a look at creating queries (views), tables and columns, indexes, and relations to help you create and modify entire databases from the ground up. Finally, you learned how to work with the Jet security model in ADO, creating groups and users, and managing object permissions.

In the next chapter, you examine VBA in some detail, which will add a great deal of context to what's been covered in Chapters 6 and 7.