Question I keep getting: "microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine"

[chazrab]

...when I set the Datasource for Listbox1 on a new userform. Went through all steps to "register" this as directed in some yt vids. Relevant snips below. Brand new to VS. What am I doing wrong that VS keeps telling me ..."not registered on the local machine.? Per a YT vid, uninstalled Access DB engine, reinstalled Access Runtime, x86. O365 2016, 64 bit machine. Please help. Must be something simple(hopefully).

Thanks to anyone in advance.
cr

 

[Skydiver]

Did you install the latest version of both the 32-bit and 64-bit drivers?

Download Microsoft Access Database Engine 2016 Redistributable from Official Microsoft Download Center

www.microsoft.com

 

[chazrab]

Hi Skydiver. Doing it now from the link you provided. ..hope this is correct. CR

 

[Skydiver]

Yes.

 

[chazrab]

These tells me I already have these files.

 

[Skydiver]

The error is not saying that you already have these files. It is saying that you have a mismatched version of Office already installed.

My apologies regarding post #2 telling you to ensure that you to install both the 32-bit and 64-bit version of the MDAC drivers. They used to be able to co-exist side by side for older versions. It looks like for the 2016 version they are now forcing you to pick the version that matches your current Office installation.

Basically, the being reported in your post #1 is due to the fact that Visual Studio 2022 is running as now running as a 64-bit application. You'll need the 64-bit MDAC drivers installed. Obviously that will be an issue if you currently have 32-bit Office installed.

 

[chazrab]

The error is not saying that you already have these files. It is saying that you have a mismatched version of Office already installed.

My apologies regarding post #2 telling you to ensure that you to install both the 32-bit and 64-bit version of the MDAC drivers. They used to be able to co-exist side by side for older versions. It looks like for the 2016 version they are now forcing you to pick the version that matches your current Office installation.

Basically, the being reported in your post #1 is due to the fact that Visual Studio 2022 is running as now running as a 64-bit application. You'll need the 64-bit MDAC drivers installed. Obviously that will be an issue if you currently have 32-bit Office installed.

Hi Skydiver - thx for replying back. I was getting discouraged and started to think about giving up trying to create my Excel/VBA Bible application in VS using it as a design model - your reply has got me re-encouraged - on this statement "Visual Studio 2022 is running as now running as a 64-bit application. You'll need the 64-bit MDAC drivers installed. Obviously that will be an issue if you currently have 32-bit Office installed."

There must be a link to download and install these drivers in O365. i Googled this quote and it took me to the page snip below. This is the correct download to make it work, I hope.

if this download works, then I should be able to populate Listbox1 on the userform with the Access DB and should show when I run the app. Thx again for staying in touch. cr

 

[chazrab]

Update: uninstalled 32 bit, reinstalled 64 bit MS ACCESS DB Engine, MSgBox Test connection = Text "succeeded"
New Listbox1, new userform. Datasource same .accb1

 

[Skydiver]

Check to see your project build properties. Make sure that you are building as x64, or if you are building as "Any CPU" that you don't have the "Prefer 32-bit" checked.

 

[jmcilhinney]

It's possible to install both 32-bit and 64-bit ACE but I'm not sure that you can install the same version of each. I was under the impression that it was possible but I've never read explicit instructions and it didn't work when I tried. What you can do is install both the 2016 and 2010 version of ACE with different bitness, so you're covered in both cases. If you have 64-bit Office installed, you can install 32-bit ACE 2010 and vice versa.

 

[chazrab]

It's possible to install both 32-bit and 64-bit ACE but I'm not sure that you can install the same version of each. I was under the impression that it was possible but I've never read explicit instructions and it didn't work when I tried. What you can do is install both the 2016 and 2010 version of ACE with different bitness, so you're covered in both cases. If you have 64-bit Office installed, you can install 32-bit ACE 2010 and vice versa.

Snips show everything I've done (that I think is correct). That Listbox should populate with the Access database, but instead the continual error msg. Not wanting to overkill on snips, just showing everything I've done that
should cause Listbox to work. Obviously, VS is still saying "...not registered on local machine". Snip shows O365 version is 64 bit. Are there steps i'm missing that registers this file? Thx to all for the efficient help efforts. cr Kingwood, Tx

 

[Skydiver]

Please show that you changed your build options:
From the main menu: Project.<Project Name> Properties... Switch to the Build tab:

Make sure that if you have "Any CPU" that you uncheck "Prefer 32-bit".

Or

that you are building for 64-bit.

 

[chazrab]

Where are these dialog boxes? . The closest I could come is the snip of the Configuration Manager. The
Main Menu on my VS is also shown. cr

 

[jmcilhinney]

It's the project properties. You can get there from the Project menu or the Solution Explorer.

 

[Skydiver]

Please start a new thread since your latest question has nothing to do about your database errors.