F. Scott Barker's Microsoft® Access 2000 Power Programming

CREATING A DATABASE WITH DAO

To help demonstrate the different objects that make up your database, you're going to learn how to create a copy of your database by using nothing but DAO. You'll copy tables, queries, and relationships property by property. You'll also copy each record in every table field by field.

Note

This example doesn't provide the most efficient method for copying a database. It does, however, demonstrate how to access and use each object in DAO.

While you move through the examples, you're told where you can go in the Access user interface to view how Access displays the information available in DAO. This should help give you a clearer picture of how DAO is organized.

You can find the Chap05.mdb database on this book's CD-ROM ...