Connection string for access 2016 in VB.NET

Question

0.00/5 (No votes)

See more:

Hello,
I used this connection string in vb.net for Access 2013

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=xx/xx.accdb; Jet OLEDB:Database Password= xx;

then after used Access 2016 it doesn't work
which connection string should I use?
Thanks,

What I have tried:

several things but doesn't work

Posted 28-May-19 22:18pm

Eman Ayad

Updated 28-May-19 22:46pm

Add a Solution

Comments

Richard MacCutchan 29-May-19 4:39am

What does "doesn't work" mean?

Eman Ayad 30-May-19 3:03am

this error message
An unhandled exception of type 'System.InvalidOperationException' occurred in System.Data.dll
Additional information: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

Richard MacCutchan 30-May-19 3:23am

"The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine."
So you need to install it. Go to Download Microsoft Access Database Engine 2016 Redistributable from Official Microsoft Download Center[^] for the download.

Eman Ayad 30-May-19 5:52am

I've already installed but with the same error message

Richard MacCutchan 30-May-19 7:14am

It may be a 32bit vs 64bit issue.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2019-05-28T22:47:00

Solution 1

The JET engine was only available for 32 bit apps, never for 64 bit.
The chances are that you have installed the 64 bit version of Access 2016, and that can't be used with JET at all.

Seriously, I'd strongly recommend you scrap JET and move to ACE which supports both 32 and 64 bit engines and code.

Posted 28-May-19 22:47pm

OriginalGriff

Comments

Eman Ayad 30-May-19 2:19am

Thanks, how can I move to ACE?

OriginalGriff 30-May-19 2:41am

Install the ACE engine:
https://datasavvy.me/2017/07/20/installing-the-microsoft-ace-oledb-12-0-provider-for-both-64-bit-and-32-bit-processing/
And change your connection string to match.