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

I seem to remember there may be a problem setting "allow zero length 
property" on field properties using SQL methods
But there is some odd workaround.

Susan Harkins wrote:

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

-- 
Marty Connelly
Victoria, B.C.
Canada