Hi Jon, Maybe there might be some helpful info from this article by r937. http://www.evolt.org/article/SQL_and_Database_Resources_on_the_Web/18/1618/i ndex.html >----------------------------------------- > Hello, > > I need to rename a column/field in an Access db (from ColdFusion). I > also need a WHERE clause with the statement which does this. > > Is this possible? (if you know the answer, you can skip the following > detailed explanation :) ) >------------------------------------------------------ Good luck Jasen James http://cbizz.net