O'Reilly logo

Access™ 2007 VBA Programmer's Reference by Armen Stein, Geoffrey Griffith, Rob Cooper, Teresa Hennig

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required