This is one of basic examples, but it shows you how to deal with various
database objects such as indexes, keys, relationships, tables, and so on.
Additionally, it tells you how to create a MS Access database file from your
codes without MS Access application in your computer, and how to use two-phase
transactions. Here is the list of answers.
How to create a *.MDB file
on the fly.
How to use two-phase
How to create tables, define
fields, set up various keys, and put indexes on fields using DDL (Data
Definition Language) statements.
How to use insert records
using SQL update statements.
How to open a rowset based
on a table name instead of SQL select statement.
In addition to this example, OleDBPro provides the example
MkTblsEx, which demonstrates using COSessionEx
functions to complete the above job instead of DDL statements.
the list of examples