What Is ADOX?

In the last several chapters, you’ve learned how to use ADO to explore and manipulate data. But there are limitations to the things that you can do with ADO. One of these limitations is that ADO can work only with objects that already exist in the database. You can’t, for example, create a new table or a new query with ADO, no matter what you do with the Connection, Command, or Recordset objects.

Many developers might never feel this limitation, but being able to create new objects from code can be incredibly useful. For example, you might have some tables that you prefer to start with in every database that you create. Wouldn’t it be nice to run a procedure to just create these tables, instead of working in the table designer?