# Alternative: check for ACE OLEDB provider in registry $providers = @( "HKLM:\SOFTWARE\Classes\CLSID\3BE786A0-0366-4F5C-8FB6-95A30E2BDB44" # ACE 12.0 "HKLM:\SOFTWARE\Classes\CLSID\3BE786A0-0366-4F5C-8FB6-95A30E2BDB45" # ACE 16.0 (2016) "HKLM:\SOFTWARE\WOW6432Node\Classes\CLSID\3BE786A0-0366-4F5C-8FB6-95A30E2BDB44" "HKLM:\SOFTWARE\WOW6432Node\Classes\CLSID\3BE786A0-0366-4F5C-8FB6-95A30E2BDB45" )
catch Write-Host "Download failed: $_" -ForegroundColor Red exit 1 /quiet - no UI, /passive - shows progress (change to /quiet for total silence) $installArgs = "/quiet /norestart"
foreach ($clsid in $providers) if (Test-Path $clsid) return $true accessdatabaseengine_x64.exe
finally # Cleanup: remove downloaded installer if (Test-Path $tempPath) Remove-Item $tempPath -Force Write-Host "Cleaned up temporary installer." -ForegroundColor Gray
Write-Host "Access Database Engine not found. Starting download..." -ForegroundColor Yellow try $webClient = New-Object System.Net.WebClient $webClient.DownloadFile($downloadUrl, $tempPath) Write-Host "Download completed: $tempPath" -ForegroundColor Green # Alternative: check for ACE OLEDB provider in
If you need to run this in an , you can invoke it from cmd like this:
if ($process.ExitCode -eq 0) Write-Host "Installation completed successfully." -ForegroundColor Green # Optional: log the installation "$(Get-Date) - Installation successful" else Out-File -FilePath $logFile -Append exit $process.ExitCode accessdatabaseengine_x64.exe
foreach ($path in $checkPaths) if (Test-Path $path) $acePath = (Get-ItemProperty -Path $path -Name "ACE" -ErrorAction SilentlyContinue).ACE if ($acePath -and (Test-Path $acePath)) return $true