I don't think access supports RENAME COLUMN, you going to have to create a new col, copy data, then drop the old col.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jake McKee Sent: Sunday, April 24, 2005 11:30 PM To: [email protected] Subject: Rename Access table name All, I'm trying to use a SQL statement to rename a column in an Access database. This is the code: <cfquery name="update" datasource="#APPLICATION.datasource#"> ALTER TABLE otherBlogs RENAME COLUMN status TO otherBlogStatus </cfquery> I'm getting a CF error saying that there is a syntax error here. Any ideas what's going on? Thanks! Jake ---------------------------------------------------------- To post, send email to [email protected] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm ---------------------------------------------------------- To post, send email to [email protected] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm
