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