title: How to access mdb file in windows10 by powershell?
body: <p>Following the suggestion that shown in the following link,
  I have created a powershell script to access the mdb file.</p>
  
  <p><a href="https://devblogs.microsoft.com/scripting/hey-scripting-guy-can-i-query-a-microsoft-access-database-with-a-windows-powershell-script/" rel="nofollow noreferrer">https://devblogs.microsoft.com/scripting/hey-scripting-guy-can-i-query-a-microsoft-access-database-with-a-windows-powershell-script/</a></p>
  
  <p>which is:</p>
  
  <pre><code>    $cn = new-object -comobject ADODB.Connection
      $rs = new-object -comobject ADODB.Recordset
      $cn.Open("Provider = Microsoft.Jet.OLEDB.4.0;Data Source = $path")
  </code></pre>
  
  <p>However, i have updated my computer to windows 10 (64bit) and installed ACCESS 2016. The powershell script does not working anymore. And it shows that the 
  Provider = Microsoft.Jet.OLEDB.4.0 is not found.</p>
  
  <p>I have tried to change the Provider = Microsoft.ACE.OLEDB.12.0
  But it does not help, as it shows the same error that the provider is not found.</p>
  
  <p>Moreover, I have tried to open it with ACCESS 2016, it also does not help as it shows that can not open the database file that created in previous version. </p>
  
  <p>Please help....</p>