| This chapter builds on a foundation begun in Chapter 7. That foundation puts you in a position to use VBA in conjunction with Excel to connect to external databases. VBA and Excel can't connect to databases without help, though. You need to provide them with an object library, one that contains information about the objects, properties, and methods found in a database. ADO and DAO are two such object libraries, and this chapter has shown you how to integrate them with your VBA code, and how to open databases by applying references to the libraries. You have also read about the theory and practice of making Access databases secure. This material was supplied because as data networks have become more and more accessible, shared databases have become the rule and it's important to secure a shared database. If you're to successfully integrate Excel, VBA, and ADO/DAO in the management of a shared database, you need to know how the database's security works. This chapter concluded with some examples of the use of VBA with DAO or ADO to legitimately open a secured database (not, that is, to break into it illicitly). Chapter 9, "Managing Database Objects," continues by showing you how to use VBA and an object library to manage database tables and queries, and their components, from the context of an Excel workbook. |
