Rename Access table name

[Jake McKee]

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 list@dfwcfug.org
To unsubscribe: 
  http://www.dfwcfug.org/form_MemberUnsubscribe.cfm
To subscribe: 
  http://www.dfwcfug.org/form_MemberRegistration.cfm