Nope. Same error. However I did namage to find the solution by guesswork
ALTER TABLE settings ADD BLAH text(10) NULL; works, and ALTER TABLE (settings ADD BLAH text(10) NULL); Does not. It's the surrounding parentheses. @#$%&!! Thanks for helping out, --Matt Robertson-- MSB Designs, Inc. http://mysecretbase.com -----Original Message----- From: Seamus Campbell [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 23, 2002 7:29 PM To: CF-Talk Subject: Re: Access Alter Table weirdness AHHH! Try this: ALTER table_name ADD COLUMN column_name column_definitions Seamus At 01:56 pm 24/03/02 , you wrote: >I can't get the supposedly dirt-simple query below to work. Can anyone >see anything wrong with my SQL? No matter what I do I get this error: > >ODBC Error Code = 37000 (Syntax error or access violation) >[Microsoft][ODBC Microsoft Access Driver] Syntax error in ALTER TABLE >statement. > >The field adds fine in other platforms (different SQL of course); adds >fine if used in a CREATE TABLE where all other fields in the table are >defined at once, but won't work no matter what I alter below. > ><CFQUERY DATASOURCE="#request.NewDSN#" DBTYPE="ODBC" NAME="MakeTable"> >ALTER TABLE cm_users ( ADD UserName text(10) NULL >); ></CFQUERY> > >Any ideas would be greatly appreciated. > >--Matt Robertson-- >MSB Designs, Inc. >http://mysecretbase.com > > > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
