Chapter 15. Programming DAO: Data Definition Language

In the overview of DAO, I noted that Data Access Objects consists of two conceptually distinct components: a data definition language (DDL), which allows us to create or access some basic database system objects, like databases, table definitions, and indexes; and a data manipulation language (DML), which allows us to perform the practical operations of adding data (records) to our tables, deleting unwanted data, and modifying existing data. In this chapter, I discuss the DDL aspects of DAO.

Let us begin by noting the following:

  • To indicate variables of a certain type, I will write the type name followed by the suffix Var. For example, DatabaseVardenotes a variable of type Database , and TableDefVar denotes a variable of type TableDef.

  • In describing the syntax of certain methods, I will use square brackets ([ ]) to indicate optional items.

  • I will generally give the full syntax of methods, but will only give details on the more common options. Of course, full details are available through the Access help system.

Creating a Database

Databases are created using the CreateDatabase method of a Workspace object. The general syntax of this method is:

SetDatabaseVar = [WorkspaceVar.]CreateDatabase _
(DatabaseName, locale [, options])


  • DatabaseName is a string expression representing the full path and name of the database file for the database being created. If you don’t supply a filename extension, then the extension .mdb is automatically ...

Get Access Database Design & Programming, 3rd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.