Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.
Solved
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=""
"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?
Thanks,
Charlie
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=""
"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?
Thanks,
Charlie
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s
ManageEngine
webinar, where attendees received a comprehensive look at the ma…
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers.
Hopes this gives you ideas on visualizing your data in new ways ~
Create a calculated field in a query:
…
Suggested Courses
Course of the Month13 days, 9 hours left to enroll
656 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.