Renaming a field in VBA using SQL??

[satchi]

Hi, I was wondering if it's possible to rename a field in Access using SQL statements? I'm using access databases and would like to rename a field of a table remotely. Thanks

 

[PHV]

What is the business case of changing the name of a column in a table ?
Who cares ?
Anyway, have a look at the DAO.TableDef.Field object (the Name property).
BTW, there is no SQL way I'm aware of, but VBA.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Remou]

VBScript may be useful.

Set catTables=CreateObject("ADOX.Catalog")

Set cn = CreateObject("ADODB.Connection")
dbfile = "C:\Docs\Tek-Tips.mdb"

cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
     "Data Source=" & dbfile & ";"

Set catTables.ActiveConnection = cn

catTables.Tables("tblTable").Columns("FieldX").Name = "FieldY"

Set catTables = Nothing

 

[satchi]

Thanks for the replies.