Thanks Charlie! Alas, in typical MS documentation form, that first link is no longer there.
HOWEVER, the GOOD news is.... THE FOLLOWING WORKED!!!! Yippeee!!! (So Bob, it worked... although I used the primary key constraint instead of NOT NULL. I can't believe I'd never noticed the "COUNTER" datatype before. <CFQUERY NAME="CreateTable" datasource="#request.dsn#" DBTYPE="ODBC"> CREATE TABLE Articles ( ArticleID COUNTER CONSTRAINT MyPrimaryKey PRIMARY KEY, Title TEXT(100), URL TEXT(255), Summary MEMO, ArchiveFlag TEXT(1), ArticleType TEXT(20), PostDate DATETIME ); </CFQUERY> FYI, here are the links I've found that still work: DDL/SQL for Access: http://support.microsoft.com/default.aspx?scid=kb;EN-US;q180841 Create Table: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/office97/xhtml/output/F1/D2/S5A320.asp Alter Table: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/office97/xhtml/output/F1/D2/S5A31A.asp thx again, carina - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: carina cojeen <[EMAIL PROTECTED]> To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net)
