Creating a table with SQL Data Definition Language w/auto incremen

[Arlan]

I have a VBA application that uses the SQL Data Definition Language (DDL) to
create tables in a jet (.mdb) database from Word XP. [e.g. CREATE TABLE
tablename (column_name, data-type);] I need to set the auto-increment
capiblity. Can I do it with DDL? If so how? If not what other option is
there and can you give me example code.

THANKS!

[Cindy M -WordMVP-]

Hi =?Utf-8?B?QXJsYW4=?=,

Post by Arlan
I have a VBA application that uses the SQL Data Definition Language (DDL) to
create tables in a jet (.mdb) database from Word XP. [e.g. CREATE TABLE
tablename (column_name, data-type);] I need to set the auto-increment
capiblity. Can I do it with DDL? If so how?

You need to ask this in a group that deals with SQL DDL. While you might find
someone in a WORD newsgroup that knows it, the chances are slim :-)

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)

[DLG]

You should be able to use the AutoNumber data type when you are defining the
column name.

Post by Arlan
I have a VBA application that uses the SQL Data Definition Language (DDL) to
create tables in a jet (.mdb) database from Word XP. [e.g. CREATE TABLE
tablename (column_name, data-type);] I need to set the auto-increment
capiblity. Can I do it with DDL? If so how? If not what other option is
there and can you give me example code.
THANKS!