I had pretty much the same question.
try this link for help
http://www.w3schools.com/sql/
----- Original Message -----
From: "CF-Talk" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 13, 2000 3:43 PM
Subject: Re: Create Table Question
> A ) is missing at the end.
> Uwe
> ----- Original Message -----
> From: "Gary Groomer" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Montag, 13. November 2000 16:31
> Subject: Re: Create Table Question
>
>
> Try the below:
>
> create table T_AddBook (
> > AddID COUNTER PRIMARY KEY,
> > Name text(20),
> > Add1 text(40),
> > Add2 text(40)
>
> Remove the PRIMARY KEY code if the filed is not to be a primary key.
>
>
> Sincerely,
>
> Gary Groomer
>
> ----- Original Message -----
> From: "Will Ryan" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Monday, November 13, 2000 6:36 AM
> Subject: Create Table Question
>
>
> > Greeting Guru's
> >
> > I'm trying to create a table in Access via CF. I need to create an
> > AutoNumber field for an ID. I don't want to create it through access as
I
> > would have to upload a 60 meg DB to our offsite server. Any suggestions
> for
> > the SQL Statement?
> >
> > create table T_AddBook (
> > AddID autonumber,
> > Name varchar (20),
> > Add1 varchar (40),
> > Add2 varchar (40)
> > )
> >
> >
> > Thanks,
> > Will
> >
> > Will Ryan
> > [EMAIL PROTECTED]
> > http://www.zerotoeighty.com
> > w: 410-327-9152
> > f: 410-327-4086
> >
>
> --------------------------------------------------------------------------
> ----------------------
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or
send
> a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]
> >
> >
>
> --------------------------------------------------------------------------
--
> --------------------
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a
> message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
>
>
>
> --------------------------------------------------------------------------
----------------------
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
>
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
