Smart questions
Smart answers
Smart people
Join Tek-Tips Forums

Member Login

Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • 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!

Join Tek-Tips
*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.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

leonardmp92 (IS/IT--Management) (OP)
28 Mar 06 22:21

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.

mp9 (Programmer)
29 Mar 06 3:23
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?
Golom (Programmer)
29 Mar 06 7:57
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.
leonardmp92 (IS/IT--Management) (OP)
29 Mar 06 9:27
Thanks guys, but I got a syntax error in the "ALTER TABLE statement" when I tried to run as mp9 listed above.

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!

Back To Forum

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