title: Microsoft.Ace.OLEDB.16.0
body: <p>Can anyone please help me understand why Microsoft.Ace.OLEDB.16.0 doesn't work on Windows 10 x64 with Office 2016 x86?
  I get runtime error  <code>-2147467259 (80004005)</code> when the connection to <code>OLEDB 16.0</code> is opened using the following code:</p>
  
  <pre><code>Public Sub ValidityDateCheck_SRT_Templates()
  
  NameFile = "x"
  
      sConn = "Provider=Microsoft.ACE.OLEDB.16.0;WSS;IMEX=1;RetrieveIds=Yes;" &amp; _
          "DATABASE=" &amp; sSHAREPOINT_SITE &amp; ";" &amp; _
          "LIST=" &amp; sDEMAND_ROLE_GUID_ML &amp; ";"
  
  Set cn = New ADODB.Connection
  Set rst = New ADODB.Recordset
  
  With cn
      .ConnectionString = sConn
      .Open  '--&gt; **HERE I GET THE ERROR**
  
  End With
  
  Rs = "SELECT * FROM [Template Library];"
  rst.Open Rs, cn, adOpenStatic, adLockOptimistic
  Do Until rst.EOF
      If Left(rst![Name], InStr(1, rst![Name], "#") - 1) = TemplateID Then
          NameFile = rst![Name]
          On Error GoTo Skip
          ActualVdate = rst![Validity Date]
          TransVdate = rst![Transition Period End]
          Exit Do
      Else
          rst.MoveNext
      End If
  Loop
  Skip:
  rst.Close
  </code></pre>
  
  <p>The interesant part is that in DEBUG, if I use 12.0 first and then change to 16.0 and save, it will open it. Then, if I reopen file, i get same error.
  Please help me guys.</p>