How do find the Microsoft provider on my machine to connect my database in VB

Question

1.00/5 (1 vote)

See more:

i am trying to run my program in VB but when i run the program it keeps saying Microsoft ACE.12.0. provider is not registered on local machine

What I have tried:

i am trying to run my program in VB but when i run the program it keeps saying Microsoft ACE.12.0. provider is not registered on local machine

Posted 18-Jul-21 17:13pm

NHYIRABA CK

Updated 18-Jul-21 19:12pm

Add a Solution

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 · 2021-07-18T19:12:00

The simple reason is the obvious one: it isn't installed on that machine.
The connections string for an Access database specifies a driver set for a specific version of software:

VB

Dim connString As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.mdb;Persist Security Info=False;";

And you need to have the right version of the database engine installed in order to use it.
In this case, you will need the right version of the Microsoft Access Database Engine 2010 Redistributable from Official Microsoft Download Center[^] pack for the word size of your application: ithe 32 bit version for 32 bit apps, and the 64 biot version for 64 bit apps.