Rename Column

[jalbao]

I am using an Access 2000 database and I'm trying to figure out how (if possible) to rename a field using a SQL statement. From what I can tell, the SQL92 "Rename Column" function is not supported in Access 2000. Any tips/work-arounds etc?

tia

 

[lupins46]

Add a new column; copy old value to new; drop old column.


sql = "ALTER TABLE MyTable ADD NewName VARCHAR(50)"
CurrentDb.Execute strSQL, dbFailOnError

sql = "UPDATE MyTable SET NewName = OldName"
CurrentDb.Execute strSQL, dbFailOnError

sql = "ALTER TABLE MyTable DROP OldName"
CurrentDb.Execute strSQL, dbFailOnError

 

[BNPMike]

...and then compact the database.