Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Changing column names in Access 2003 SQL

Changing column names in Access 2003 SQL

Changing column names in Access 2003 SQL


Using Access 2003. I have an existing table and am trying to rename a column to a new name. I know I have to use the ALTER TABLE statement, but then I am not sure how to rename the column. All the references I have show difference "dialects" to rename.

Wondering if anybody can help.

Thank you.

RE: Changing column names in Access 2003 SQL

I think the only thing you can change with an ALTER COLUMN statement within an ALTER TABLE is data type.

To rename in SQL, I think you'll need to add a new column with tthe name you want, update that column with the value from the old column, then drop the old column.

Maybe you can play with TableDef in VBA to do the renaming?

RE: Changing column names in Access 2003 SQL

As mp9 says, you need to do this in a multi-step process


ALTER TABLE myTable ADD COLUMN NewColumn Text(255)

UPDATE myTable SET NewColumn = OldColumn

The RENAME COLUMN functionality isn't supported (as far as I'm aware) in Access.

RE: Changing column names in Access 2003 SQL

Thanks guys, but I got a syntax error in the "ALTER TABLE statement" when I tried to run as mp9 listed above.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close