The provider "Microsoft.ace.oledb.12 is not registered on the local computer

This error occurs when trying to make a connection string with the Access database in a Visual Basic application

What is "Microsoft Access Data base Engine", in Spanish it means "Microsoft Access database engine", this is a component that makes possible the interaction between services and applications that are not proprietary Windows, an example of this is if you are working with the Microsoft Access database directly it needs to establish a link to export tables, that is why the database engine is needed.

There are different versions in which Microsoft Access is available, this depends on the product of the same office.

Advantage:

Connects Microsoft Office products that do not belong to the product.

Easy to use and download.

Now we are going to process with the solution, one of these three versions must be installed so that the problem stops appearing.

Disadvantages:

No 64-bit version for Database Engine 2016

Solution number # 1

Link to download Microsoft AccessData base Engine 2007.

Link to download Microsoft AccessData base Engine 2010.

Link to download Microsoft AccessData base Engine 2016.

The steps are easy to install just download and run the ".exe" file.

Solution number # 2

This is a solution if number 1 does not work, the following would be how this error happens when there are no office 2007 drivers for 64-bit platform, and you just have to change the compilation options in the project property.