Microsoft.ACE.OLEDB16.0提供程序未在本地计算机上注册 [英] Microsoft.ACE.OLEDB16.0 provider is not registered on the local machine

问题描述

我正在使用Visual Studio 2013和Access 2016，但我找不到此问题的任何补丁。我已经下载了一堆补丁，并且在连接字符串中编写了OLEDB12.0,15.0和16.0，并且无论如何我都会收到此错误。
有人可以帮我吗？ 

I am using Visual Studio 2013 and Access 2016 and I can't find any patches for this issue. I have downloaded a bunch of patches and played around with writing OLEDB12.0, 15.0, and 16.0 in the connection string and I keep getting this error regardless. Can someone please help me out? 

推荐答案

嗨DepressedDiva，

Hi DepressedDiva,

根据你的说法说明，您似乎没有在本地计算机上安装ACE提供程序。

According to your description, it seems that you don't install ACE provider on your local machine.

由于默认情况下Windows操作系统上未安装ACE提供程序。你必须安装它。 ACE提供程序有两种形式：
Microsoft Office Access数据库引擎2007 和 
Microsoft Access数据库引擎2010可再发行组件。 2007版本仅作为32位组件提供，而2010版本提供32位和64位选项。你需要
来注意你选择哪个选项，因为这里错误的选择是导致错误信息的最常见原因。

Since the ACE provider is not installed on Windows operating systems by default. You have to install it. The ACE provider is available in two forms: Microsoft Office Access database engine 2007 and  the Microsoft Access Database Engine 2010 Redistributable. The 2007 version is only available as a 32-bit component whereas the 2010 version offers both 32 and 64-bit options. You need to be careful which option you choose, because a wrong choice here is the most frequent cause for the error message.

有关更多信息，请参阅：

For more information, please refer to：

http://www.mikesdotnetting.com/article/280/solved-the-microsoft-ace-oledb-12-0-provider-is-not-registered-on-the-local -machine

祝你好运，

Cole Wu

这篇关于Microsoft.ACE.OLEDB16.0提供程序未在本地计算机上注册的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！