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/[email protected]/
> 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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
