Is there an Access SQL function to rename a column?

I tried the following:
ALTER TABLE tablename RENAME oldcolumn newcolumn;

ALTER TABLE tablename REN oldcolumn newcolumn;

ALTER TABLE tablename RN oldcolumn newcolumn;

all do not work.

Checked the Access SQL reference - found no reference to renaming
columns.
Any ideas?

On Sun, 4 Apr 2010 20:56:57 -0700 (PDT), bubbles
<bubbles.one (AT) hotmail (DOT) com> wrote:

Perhaps you can use three statements: one using the ADD COLUMN clause,
one using an UPDATE statement to copy the data over, and one using the
DROP COLUMN clause.

-Tom.
Microsoft Access MVP

Thank you, Tom. That was what I did.
I am surprised that this action is not supported in Access SQL.



On Apr 5, 12:14*pm, Tom van Stiphout <tom7744.no.s... (AT) cox (DOT) net> wrote:

On 7 Apr., 10:17, bubbles wrote:
http://databases.aspfaq.com/database...-a-column.html ),
Access cannot.

Maybe they wonted to protect us against ourselves, as renaming a
column can break joins. But then it is easy to rename columns in VB.
Who knows?

Greetings
Marco P