Hi all,
I’m trying on my win 7 pc to make a powershell script that adds a row to a access mdb file.(office 2013 32 bit).
But it fails every time, I have already install AccessDatabaseEngine.exe but without success, my code and the error:
$Ado = New-Object -ComObject ADODB.Connection $recordset = New-Object -ComObject ADODB.Recordset$Ado.Open("Provider = Microsoft.ACE.OLEDB.12.0;Data Source=d:\test.mdb");
Maar dan krijg ik : Exception calling “Open” with “1” argument(s): "Kan de voorziening niet vinden. Mogelijk is deze niet juist geïnstalleerd."At D:\importinaccess.ps1:28 char:12+ $Ado.Open <<<< ("Provider = Microsoft.ACE.OLEDB.12.0;Data Source=d:\test.mdb")+ CategoryInfo : NotSpecified: ( , MethodInvocationException
Can someone help me please?
Kind regards