利用ADOX更改字段名

Function Test()
ChangeTableFieldName_ADO "表1", "aa", "pic1"
End Function

Function ChangeTableFieldName_ADO(MyTableName As String, MyFieldName As String, strNewName As String)
'3个参数：
'MyTableName 字符串，表名
'MyFieldName 字符串，原来的字段名
'strNewName 字符串，新的字段名
'记得先引用 ADOX
Dim MyDB As New ADOX.Catalog
Dim MyTable As ADOX.Table
MyDB.ActiveConnection = CurrentProject.Connection
Set MyTable = MyDB.Tables(MyTableName)
MyTable.Columns(MyFieldName).Name = strNewName
End Function