Creating and Modifying Database Objects Using Code

When developing an Access application, it might be useful to add tables or queries, define or modify relationships, change security, or perform other data-definition techniques at runtime. You can accomplish all this by manipulating the various data access objects.

Adding a Table Using Code

Many properties and methods are available for adding and modifying Jet Engine objects. The code in Listing 15.33 creates a table, adds some fields, and then adds a primary key index.