Use Alter Table to change column name

[traingamer]

Can I use 'Alter Table' to change a column name in Access? If so, what is the format?
OR do I have to add a new column, copy the data from the old column, and drop the old column?

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[Remou]

Hi
Would tabledefs be any use to you?

    Dim dbs As Database, tdf As TableDef
    ' Return reference to current database.
    Set dbs = CurrentDb
    ' Create TableDef object.
    Set tdf = dbs.TableDefs("Contacts")
    tdf.Fields("ContactNo").Name = "Blah"
    'Debug.Print tdf.Fields("ContactNo").Name
    Set dbs = Nothing