table

[Guest]

hello

is there is any way I can rename the fields of a table
from code

Ex: For Table client rename the field F1 ==> ID_Client

Thanks

 

[Dirk Goldgar]

hello

is there is any way I can rename the fields of a table
from code

Ex: For Table client rename the field F1 ==> ID_Client

Thanks

Something like this air code:

Dim db As DAO.Database
Dim tdf As DAO.TableDef

Set db = CurrentDb
Set tdf = db.TableDefs("Client")

tdf.Fields("F1").Name = "ID_Client"

Set tdf = Nothing
Set db = Nothing