renaming a field in a table in visual basic

[Pierre Laporte]

I need to rename some field in many databases in Visual Basic. I know how to
create fields using .CreateField.
I am using Office 2000.

 

[Douglas J. Steele]

Assuming you've got a reference set to DAO, you can use

CurrentDb().TablesDefs("NameOfTable").Fields("OldFieldName").Name =
"NewFieldName"

 

[Pierre Laporte]

Thanks Doug,

It worked with

CurrentDb().TableDefs("NameOfTable").Fields("OldFieldName").Name =
"NewFieldName"