renaming a field in a table in visual basic

  • Thread starter Thread starter Pierre Laporte
  • Start date Start date
P

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.
 
Assuming you've got a reference set to DAO, you can use

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

It worked with

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