Rename table columns in Access 2000

[Del]

Is there a way to rename a table column with Alter Table & Alter Column?

 

[Dirk Goldgar]

Is there a way to rename a table column with Alter Table & Alter Column?

I don't believe you can do this directly via DDL statements. You could use
ALTER TABLE ADD COLUMN to create a column with the new name, then execute an
update query to copy data from the old column to the new column, and then
use ALTER TABLE DROP COLUMN to delete the old column.

Or you could use DAO or ADOX to rename the column. For example,

' DAO example, in short form.
CurrentDb.TableDefs("MyTable").Fields("OldFieldName").Name =
"NewFieldName"