[thelist] Create table SQL and MSAccess syntax

[jon steele]

Hi everyone,

I am using the following as my create table syntax in
the cfquery tag:

CREATE TABLE #table_name#(
id int PRIMARY KEY AUTO_INCREMENT,
my_title text,
my_text text
);

However, I am receiving a syntax error. I found out
that the 'AUTO_INCREMENT' was giving the error. I took
it out and it worked fine, but I need the
AUTO_INCREMENT. How can I get my sql to set the field
as AUTO_INCREMENT?

Thanks in advance.
Jon.

__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/