System.InvalidOperationException: 'The 'Microsoft.ACE.OLEDB.NN.0' provider is not registered on the local machine.'

Kai 0

This is not a repost of questions other people have asked. I have spent nearly a week reading all posts from other people and downloading this and that. I haven't downloaded the 32-bit version when I have 64-bit office, or any other problems that have been listed online. I have downloaded Microsoft Access Database Engine 2016, and it still seems to give me the same error. When I ran the code at school the number was 12.0 and it ran perfectly, although it seems that that version is no longer available for download. I am programming in VB with .NET windows application framework. How do I fix this.

Ateeq ur rahman 0

Here are a few steps you can try to fix the issue with the Microsoft Access Database Engine:

Ensure Correct Version: Double-check that you have the correct version of the Microsoft Access Database Engine installed. Since you’re using a 64-bit version of Office, make sure you have the 64-bit version of the Access Database Engine 2016 installed 1.

Registry Fix: Sometimes, the issue can be related to registry settings. You can try the following steps:

Open Command Prompt as an administrator.

Run the following command to install the Access Database Engine silently:

      AccessDatabaseEngine_x64.exe /quiet

- After installation, open the Registry Editor (regedit) and navigate to:

```
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\16.0\Common\FilesPaths
```

   - Ensure that the path to the **`ACEOLEDB.DLL`** file is correctly set.

   **Connection String**: Make sure your connection string in your VB.NET application is correctly set to use the **`Microsoft.ACE.OLEDB.12.0`** provider. It should look something like this:

   ```
   Dim
   ```

   **Reinstall Office**: If none of the above steps work, you might need to uninstall and then reinstall Office. [Sometimes, conflicts between different versions of Office components can cause issues](https://superuser.com/questions/1557350/how-to-resolve-you-cannot-install-the-32-64-bit-version-of-microsoft-access-da)[2](https://superuser.com/questions/1557350/how-to-resolve-you-cannot-install-the-32-64-bit-version-of-microsoft-access-da).

   **Check for Updates**: Ensure that your system and all related software are up to date. Sometimes, updates can fix underlying issues.

If these steps don’t resolve the issue, please let me know any specific error messages you’re encountering, and we can dig deeper into the problem. Good luck, and I hope this helps!

Kai 0 Reputation points

2024-07-31T10:46:12.0633333+00:00

Ateeq ur rahman

First command returns this:

'AccessDatabaseEngine_x64.exe' is not recognized as an internal or external command, operable program or batch file.
Kai 0 Reputation points

2024-07-31T10:48:10.8633333+00:00

Ateeq ur rahman

First command returns this:

'AccessDatabaseEngine_x64.exe' is not recognized as an internal or external command,

operable program or batch file.

(Sorry about 2 comments the first one didn't appear until I made a second one)

1 answer

Jiachen Li-MSFT 31,326 Reputation points Microsoft Vendor

2024-07-31T02:18:02.0666667+00:00

Hi @Kai,

Right-click your project->Go to project properties->Complie tab->Target CPU Change between x86 , x64 and AnyCPU validate your selection and run debug to test.

Best Regards.

Jiachen Li

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.
Please sign in to rate this answer.
Kai 0 Reputation points

2024-07-31T11:05:56.0733333+00:00

Sorry I don't quite understand what you are saying. Where am I right clicking my project? I tried the actual file and in the solution explorer in VS2022. Neither had a "project properties" and the actual file's properties had no "build tab". Can you please elaborate further?

Thanks in advance.

Jiachen Li-MSFT 31,326 Reputation points Microsoft Vendor

2024-08-01T02:12:55.1866667+00:00

Hi @Kai,

Check the following screenshots.

or

Kai 0 Reputation points

2024-08-02T10:41:13.86+00:00

My only option is Any CPU.

Jiachen Li-MSFT 31,326 Reputation points Microsoft Vendor

2024-08-05T01:56:21.4366667+00:00

Hi @Kai,

Go to the menu bar and select Build > Configuration Manager.

In the Configuration Manager window, you'll see the Active Solution Configuration and Active Solution Platform dropdowns.

In the Active Solution Platform dropdown, select <New...>.

In the New Solution Platform dialog, you can choose to copy settings from "Any CPU" and then select either "x86" or "x64" from the New Platform dropdown.

Click OK to create the new platform.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

System.InvalidOperationException: 'The 'Microsoft.ACE.OLEDB.NN.0' provider is not registered on the local machine.'

1 answer

Your answer