Click here to Skip to main content
15,311,717 members
Please Sign up or sign in to vote.
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
Updated 18-Jul-21 19:12pm

1 solution

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.
   

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900