Access™ 2007 VBA Programmer's Reference

6.13. Summary

In this chapter, you took a detailed look into the world of DAO including powerful new features that have been added in Access 2007. By now you should have a fairly good understanding of when to use DAO, and how to refer to its objects. You should have a good working knowledge of the main objects in the hierarchy, such as the DBEngine, Workspace, Error, Database, and Recordset objects, and their associated collections. Although very few people can remember every single property and method of every object, you should have gained enough exposure to them by now, to be able to start writing some reasonably sophisticated software. In any case, IntelliSense can help you out when you're unsure.

Now that you've mastered DAO, you're ready to tackle a whole new object model—ActiveX Data Objects.