Oledb 4.0 [repack] - Download Microsoft Jet
Set conn = CreateObject("ADODB.Connection") conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\data\old.mdb"
You must match the provider bitness to your application's bitness. download microsoft jet oledb 4.0
If you want to troubleshoot a specific app or setup, let me know: What are you running? Is your application 32-bit or 64-bit ? What error message are you seeing? Set conn = CreateObject("ADODB
To summarize:
$conn = New-Object System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Windows\system32\empty.mdb;") try $conn.Open() Write-Host "Jet OLEDB 4.0 is working." -ForegroundColor Green $conn.Close() catch Write-Host "Jet OLEDB 4.0 is NOT available." -ForegroundColor Red Write-Host $_.Exception.Message download microsoft jet oledb 4.0
Change your connection string from Provider=Microsoft.Jet.OLEDB.4.0 to: Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\yourdb.accdb; .