Example MkTbls:

        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.      

1. How to create a *.MDB file on the fly.

2. How to use two-phase transactions.

3. How to create tables, define fields, set up various keys, and put indexes on fields using DDL (Data Definition Language) statements.

4. How to use insert records using SQL update statements.

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

Goto the list of examples