VB.NET problem connecting to Access Database OLEDB.4.0
Posted on 2014-12-16
I am using VB.NET 2013 and an Access database (myDatabase.MDB) . My program runs fine in Debug mode but when I tried to run in Release mode I get the following error:
The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine
I am running this as an x86 application on Windows 7, 64-bit OS. The connection string is as follows:
constr = "Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database L" & _
"ocking Mode=1;Jet OLEDB:Database Password=;Data Source=" & DatabaseName & ";Password=;Jet OLEDB:Engine Type=5;Jet" & _
" OLEDB:Global Bulk Transactions=1;Provider=""Microsoft.Jet.OLEDB.4.0"";Jet OLEDB:S" & _
"ystem database=;Jet OLEDB:SFP=False;Extended Properties=;Mode=Share Deny None;Je" & _
"t OLEDB:New Database Password=;Jet OLEDB:Create System Database=False;Jet OLEDB:" & _
"Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=Fals" & _
"e;User ID=Admin;Jet OLEDB:Encrypt Database=False"
Where DatabaseName = myDatabase.MDB
After some research it appears that there is some compatibility issue with OLEDB4.0 and a 64-bit OS but I cannot seem to find an answer that seems to address the problem.
The MS Office is Version 2013
Can anyone help solve this problem?