ALTER TABLE problem

[aziz rasul]

I have the following code: -

strSQL = "ALTER TABLE tmp RENAME COLUMN a TO aa;"
DoCmd.RunSQL strSQL

I get an error which says that the ALTER TABLE statement is wrong!!!!

 

[modest]

I don't beleive that RENAME syntax is available in Access 2003. It was implemented in Oracle 9i.

To rename a column:
- With SQL:
- - add a new column with the same variable type
- - update it with the old data
- - drop the old column
- With VBA:
- - simply use a DAO tabledef and change the field name

 

[aziz rasul]

That explains it. Thanks.