ReNaming a table's field name with VBA

C

Charlie

Is it pretty simple to rename the field [businessphone] in table [tbcontacts]
to a different name?
thanks,
charlie (CK)
 
D

Douglas J. Steele

Yup, it's pretty simple.

Using DAO, it would be:

CurrentDb().TableDefs("tbcontacts").Fields("businessphone").Name =
"busphone"
 
Top