On Win11Pro 64-bit ARM, Visual Studio 2022 cant connect to MS Access (all 64-bit)

Amit Zuker 0 Reputation points
2023-03-18T18:41:38.55+00:00

I always get the "Microsft.ACE.OLEDB.12.0 provider is not registered on the local machine" error (see the attached screen capture).

When trying to configure the ODBC admin I get the 193 error "the setup routine ODBC driver could not be loaded" (attach screen capture).

I tried all solutions found online... installed the 2010 redistributable, the 2016 redistributable, even thhe 2013 runtime (even though I have Office 365 installed...), the driver for ODBC... NOTHING HELPS and I'm stuck.
Please help!!

Why can't 2 Microsoft softwares talk to one another smoothly?

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,577 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
298 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Tianyu Sun-MSFT 27,106 Reputation points Microsoft Vendor
    2023-03-24T09:25:35.3766667+00:00

    Hi @Amit Zuker ,

    Thank you for sharing the screenshots.

    I notice that you mentioned you have installed the 2010 redistributable package. May I ask if you download it from here: Microsoft Access Database Engine 2010 Redistributable? If so, the most important thing is that can you confirm that you selected and installed the 64-bit one? If you installed the 32-bit one, please open Control Panel, find and right-click to uninstall it. After that install the 64-bit one and restart VS => reconnect to Access again.

    Please feel free to let us know if it works.

    Sincerely,

    Tianyu

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.