vb.net cannot connect to MS Access database

jinshou xiao 26 Reputation points

Here is my steps:

  1. Download and install MS Access database engine 2016, and I can query sample databases. Please note I have a 64 bit PC, but I have to install 32 bit as the set-up instructed.
  2. In my vb.net project, I want to connect to the MS Access. In visual studio I NuGet System.Data.Oledb. In visual basic code I use "Provider=Microsoft.ACE.OLEDB.12.0" to connect. but I got an error:

The 'Microsoft.ACE.OLEDB.12.0' provider is not registered in the local machine.

  1. I follow the link https://learn.microsoft.com/en-us/answers/questions/ask.html
    to enable 32 bit, still get the same OLEDB error
  2. In control panel I cannot find the drivers of Microsoft.ACE.OLEDB.12.0.

My question is where can I download the OLEDB or ODBC driver to connect to MS Access?


An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
2,400 questions
{count} vote

Accepted answer
  1. Castorix31 79,821 Reputation points

    I installed both 32 and 64-bit versions on my OS (Windows 10, 64-bit, but Office 2016 32-bit ) (with flag /quiet)
    from Microsoft Access Database Engine 2016 Redistributable
    and it works with "Provider=Microsoft.ACE.OLEDB.12.0" or "Provider=Microsoft.Jet.OLEDB.4.0"

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful