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

chazrab

Member
Joined
Nov 11, 2022
Messages
23
Programming Experience
10+
...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
ESTABLISHING CONNECTION STEP.jpg
 

Attachments

  • ERROR MSG WHEN TEST CONNECTION BUTTON PRESSED.jpg
    ERROR MSG WHEN TEST CONNECTION BUTTON PRESSED.jpg
    109.2 KB · Views: 45
  • ESTABLISHING CONNECTION STEP.jpg
    ESTABLISHING CONNECTION STEP.jpg
    140.6 KB · Views: 46
  • ACCESS DB I'M TRYING TO CONNECT TO.jpg
    ACCESS DB I'M TRYING TO CONNECT TO.jpg
    129.5 KB · Views: 40
Last edited by a moderator:
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
 

Attachments

  • ACCESS VERSION.jpg
    ACCESS VERSION.jpg
    117.6 KB · Views: 14
  • SAME RESULT WHEN I RUN THE APP.jpg
    SAME RESULT WHEN I RUN THE APP.jpg
    111.6 KB · Views: 13
  • SHEET2BINDINGSOURCE. IS THIS CORRECT -.jpg
    SHEET2BINDINGSOURCE. IS THIS CORRECT -.jpg
    99.9 KB · Views: 13
  • SELECTED DB OBJECTS.jpg
    SELECTED DB OBJECTS.jpg
    22.4 KB · Views: 13
  • TEST CONNECTION OK.jpg
    TEST CONNECTION OK.jpg
    149.8 KB · Views: 12
  • TEST CONNECTION OK.jpg
    TEST CONNECTION OK.jpg
    149.8 KB · Views: 13
  • DATASOURCE SELECTION.jpg
    DATASOURCE SELECTION.jpg
    90.3 KB · Views: 12
  • ACCESS VERSION.jpg
    ACCESS VERSION.jpg
    117.6 KB · Views: 15
Please show that you changed your build options:
From the main menu: Project.<Project Name> Properties... Switch to the Build tab:
1668479226442.png

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

Or
1668479307084.png

that you are building for 64-bit.
 
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
 

Attachments

  • CONFIGURATION MGR.jpg
    CONFIGURATION MGR.jpg
    95.4 KB · Views: 17
  • MAIN MENU.jpg
    MAIN MENU.jpg
    144.3 KB · Views: 17
Please start a new thread since your latest question has nothing to do about your database errors.
 
Back
Top Bottom