FW: [AccessD] Using CREATE TABLE scripts in Access?

Awesome!  I was trying INCREMENT and AUTONUMBER and getting nowhere.

Where did you look at up, BTW?  I was unab;e to find it in the A2K3
Help files.

-Christopher-

---- Original Message ----
From: ssharkins at bellsouth.net
To: accessd at databaseadvisors.com, 
Subject: RE: FW: [AccessD] Using CREATE TABLE scripts in Access?
Date: Mon, 3 May 2004 20:31:09 -0400

>Sorry... Thats AUTOINCREMENT
>
>CREAT TABLE Table
>(Field AUTOINCREMENT, ....)
>
>Don't even need the ADD -- should've looked it up first. I'm sorry. 
>
>Susan H.  
>
>CREATE TABLE table
>ADD COLUMN colname datatype
>
>where datatype is "increment" or "counter"
>
>...I think anyway. 
>
>Susan H. 
>
>I'm using a CREATE TABLE script to update a client's back-end 
>database since
>he refuses to take it offline or allow me after-hours access.
>
>I know how to do a CREATE TABLE script and set a primary key and all 
>that,
>but I need to create an AutoNumber field.  I'm not sure how to 
>script that.
>
>Does anyone know?
>
>-Christiopher-
>
>--
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>-- 
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>