title: MS Access column name with Portuguese accents
body: <p>I have a lot of databases I would like to change their column names. These databases were designed by a team which used Portuguese words for column names. I have managed to change names with spaces but when I try to change the names for columns with Portuguese accents e.g <code>Instalaçao</code>, my VBScript fails with error <code>item not found in this collection</code>. My VBScript is for changing this column is as below.</p>
  
  <pre><code>tblName = "CONSUMIDORES"
  oldColName = "[Instalaçao]"
  newColName = "INSTALACAO"
  
  Set dbe = CreateObject("DAO.DBEngine.120")
  Set db = dbe.OpenDatabase(dbPath)
  Set fld = db.TableDefs(tblName).Fields(oldColName)
  fld.Name = newColName
  </code></pre>
  
  <p>This code works for other columns with spaces but for accented words it fails. I am using MS Access 2013. I am new to VBScript.</p>