Defining an access table via VBA (SQL DDL)

A

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!
 
J

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()"
 
A

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
 
Top