[AccessD] Using CREATE TABLE scripts in Access?

Susan Harkins ssharkins at bellsouth.net
Mon May 3 19:28:55 CDT 2004


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