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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Arlan - 21 Jun 2005 07:56 GMT

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!

Reply to this Message

Cindy M -WordMVP- - 23 Jun 2005 11:37 GMT

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

> 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 :-)

Reply to this Message

DLG - 30 Jun 2005 14:44 GMT

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

>I have a VBA application that uses the SQL Data Definition Language (DDL)
>to
[quoted text clipped - 4 lines]
>
> THANKS!

Reply to this Message

Rate this thread: