title: DAO.DBEngine Class No Longer Registered in MS Access 2016 using Windows 10
body: <p>A client recently upgraded from Windows 7 to 10 and moved from Access 2013 to 2016 (Included with Office 365).</p>
  <p>A VBA macro in Excel now generates the following error:</p>
  <p>&quot;Run-time error '-2147221164 (80040154)' Class Not Registered.&quot; at the line:</p>
  <pre><code> Set myEngine = New DAO.DBEngine
  </code></pre>
  <p>I verified that DAO 3.6 is included in Resources. One site suggested &quot;fixing&quot; the Office install, which I did to no effect.</p>
  <p>This <a href="https://stackoverflow.com/a/32637081/1422252">response</a> suggests moving to ADO, which I might be willing if I could find some examples of how to do so.</p>
  <p>Here is the relevant code:</p>
  <pre><code>Option Base 1
  Sub importPLCDataFromAccess(monthToImport As Date)
  
  'This sub imports Influent and Effluent Data from the Access Database PLC_Data.mdb
  '   This database reads records from the PLC board on a daily basis and was created
  '    using Automation Direct's PointOfView software for interfacing with PLC Boards
  
  Dim myDbLocation As String
  myDbLocation = &quot;K:\Users\WWTP Computer\Documents\POV_Projects\PLC Interface\PLC_Data.mdb&quot;
  
  Dim myWorkbook As Workbook
  
  'Skip spurious stuff ... 
  
  Dim myEngine As DAO.DBEngine
  Dim myDB As DAO.Database
  Dim myRecordSet As DAO.Recordset
  Dim myWorkSpace As DAO.Workspace
  
  'Skip more spurious stuff ... 
  
  Set myEngine = New DAO.DBEngine ' This is the offending line
  
  Set myDB = myEngine.OpenDatabase(myDbLocation)
  </code></pre>
  <p>It seems like I am missing something elementary here. Any help is appreciated.</p>