Defining an access table via VBA (SQL DDL)

[Arlan]

Using the SQL Data Definition Language, in VBA (Word XP) can I set the
newvalues to increment to create an autonumber field? If so How?

THANKS!

 

[Jezebel]

You set the field attribute to dbAutoIncrField. If you want the auto numbers
to be random rather than incremental, you append the field to the table,
then set its default value to "GenUniqueID()"

 

[Arlan]

Can you do this using the SQL Data Definition Language (DDL)? If so, could
you give me an example. If Not could you give a brief example not using DDL?

THANKS

 

[Arlan]

I found the anwser. You use a data type of 'autoincrement' Works great.