VB.NET problem connecting to Access Database OLEDB.4.0

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?

Who is Participating?
Éric MoreauConnect With a Mentor Senior .Net ConsultantCommented:
are both debug and release targeting x86 platform? Currently, your Release mode is surely set to Any Cpu. Change it to x86.
charlieb01Author Commented:
You're the man!  I found all kinds of stuff on the net telling me I had to download stuff and that just didn't make sense.
This is why I belong to E-E!

Thanks again,
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.