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