Matt, Drop the parentheses...
<CFQUERY DATASOURCE="#request.NewDSN#" DBTYPE="ODBC" NAME="MakeTable"> ALTER TABLE cm_users ADD UserName text(10) NULL; </CFQUERY> This query works in Access 2000. HTH, Jeff Garza -----Original Message----- From: Matt Robertson To: CF-Talk Sent: 3/23/02 7:56 PM Subject: Access Alter Table weirdness AHHH! 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 ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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
