Thanks for that observation. Actually, I see now that none of the links in the magazine article work anymore. But you're right, that's the MS way. Not even any breadcrumbs to find our way. But it was from July of 2000, so perhaps they can be forgiven.
Anyway, I've added that clarification (And thanks to you, Carina) in the feedback area at the bottom of the online article. And I'll also list the site's you did find. Finally, here's one more that may help any Access user: it's a list of various Access resources on the MS site: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/htm l/acacclinks.asp /charlie -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of carina cojeen Sent: Wednesday, March 06, 2002 8:53 AM To: [EMAIL PROTECTED] Subject: Re: [CFTALKTor] AUTO_INCREMENT 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/xh tml/output/F1/D2/S5A320.asp Alter Table: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/office97/xh tml/output/F1/D2/S5A31A.asp thx again, carina - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: "charles arehart" <[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)
