Access 2003 VBA Programmer's Reference

7.10. 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 should have a fairly good working knowledge of creating and using ADO connections and transactions, and be able to 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. We also covered persistent and disconnected recordsets, and examined the use of multiple SELECT clauses, shaped queries, and schema recordsets. You should also be fairly confident of your understanding of ADO events.

Specifically relating to ADOX, we undertook an in-depth tutorial on creating queries (views), tables and columns, indexes, and relations to help you create and modify entire databases from the ground up. Finally, we examined how to work with the Jet security model in ADO, creating groups and users, and managing object permissions.

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