Modifying Existing Database Objects

You can use DAO to modify the structure of existing objects. However, there are things that you can’t programmatically alter by using DAO. For example, you can’t use DAO to change the Type property of a Field object in a table. Because this would change the data type of the field and require a conversion of existing data in the table, you must delete the Field object and then re-create it, specifying the new data type.

See Also For complete information about modifying database objects, see Chapter 3, “Data Definition and Integrity.”