18. Creating Objects with ADOX

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 ...

Get Business solutions Automating Microsoft now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.