Here is my steps:
- 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.
- 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.
- I follow the link https://learn.microsoft.com/en-us/answers/questions/ask.html
to enable 32 bit, still get the same OLEDB error
- 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?