John W. Colby
jwcolby at colbyconsulting.com
Mon May 3 19:59:49 CDT 2004
>Where did you look at up, BTW? I was unable to find it in the A2K3 Help files. They don't call it NOT Help for nothing! ;-) John W. Colby www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Christopher Hawkins Sent: Monday, May 03, 2004 8:45 PM To: accessd at databaseadvisors.com Subject: RE: 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 > -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com