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

Susan Harkins ssharkins at bellsouth.net
Mon May 3 19:31:09 CDT 2004


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




More information about the AccessD mailing list