Chapter Summary

In this chapter you were introduced to working with ActiveX Data Object libraries. You learned how to set up references to necessary object libraries using the References dialog box available from the Visual Basic Editor window. You also mastered the art of programmatically connecting to native Microsoft Access databases and files as well as to external databases and files. You saw how you can connect to various data sources using DSN and DSN-less connections. In addition, you created a brand new Microsoft Office Access database from scratch by using ADO. You also learned how to copy and compact a database and get information about the errors from ActiveX Data Objects.

In the next chapter, you will learn how to use ADO features to create and link tables, add and modify fields, and set up keys, indexes, and relationships between tables. In other words, you will learn which ADO objects can give you access to the structure of the database.

Chapter 11

0 0

Post a comment