I'd like to proven wrong on this, but I think you're at the mercy of Jet-SQL
which doesn't allow direct manipulation of numerous properties of an Access
table.
e.g. Default Value, AutoNumber types, etc...
> -----Original Message-----
> From: Will Ryan [SMTP:[EMAIL PROTECTED]]
> Sent: 13 November 2000 14:36
> To: CF-Talk
> 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]
-----------------------------------------------
Any opinions expressed in this message are those of the individual and not necessarily
the company. This message and any files transmitted with it are confidential and
solely for the use of the intended recipient. If you are not the intended recipient
or the person responsible for delivering to the intended recipient, be advised that
you have received this message in error and that any use is strictly prohibited.
Sapphire Technologies Ltd
http://www.sapphire.net
------------------------------------------------------------------------------------------------
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]
