This chapter noted at the outset that ADO isn't well suited to creating new databases; its strength lies in moving data back and forth between a database and some other application such as Excel.
Therefore, if you're using Access and its Jet database engine as the database, it makes good sense to create your databases either using DAO (as shown in this chapter's prior sections) or directly with the database's user interface. If you're using another DBMS, such as SQL Server, it's far easier to use its interface to create the database.
However, after the database exists, ADO offers tools that are entirely appropriate for creating new tables, fields, and other structures. What follows is an example of how to set up a table using ADO.
