'microsoft.ace.oledb.16.0'提供程序未在本地计算机上注册 [英] The 'microsoft.ace.oledb.16.0' provider is not registered on the local machine

问题描述

在处理项目时，我正在尝试使用Visual Studion IDE连接到MS Access DB，但每当我运行程序时，Chrome浏览器都会显示Microsoft.ACE.OLEDB.16.0未注册。 />


我已经通过很多网站解决了这个问题，但还没有解决。



我我正在使用Office 2016，Windows 10（64位）。



我尝试过：



我已经从微软网站下载了兼容性和分发平台，但问题似乎还没有解决。

While working on a project, I am trying to connect to MS Access DB using in Visual Studion IDE but whenever I run the program, the chrome browser displays that 'Microsoft.ACE.OLEDB.16.0' is not registered.

I've been through many sites to resolve the issue but it has not been solved yet.

I am working on Office 2016, windows 10 (64 bit).

What I have tried:

I have downloaded the comp-ability and distribution platforms from the Microsoft websites but the issue doesn't seem to be solved still.

推荐答案

您必须从Microsoft官方下载中心下载并安装Microsoft Access数据库引擎2010可再发行组件 [ ^ ]至能够在y中使用它我们的项目。

You have to download and install Microsoft Access Database Engine 2010 Redistributable from Official Microsoft Download Center[^] to be able to use it in your project.

一些事情...



首先，您安装了哪个版本的Office 2016？如果它是32位版本的Office，则必须针对x86的平台目标编译您的应用程序，而不是AnyCPU。进入你的项目属性，然后单击Build选项卡，你会在那里找到它。



如果你安装了Office 2016 Click-To-Run，您必须安装单独的Access运行时。如上所述，您可以安装2010版本或2013版本。这没关系。 （如果您尝试安装2016版本，它会告诉您无法安装它，因为您已经安装了2016点击运行。）



完成安装后，您必须更改连接字符串以使用正确版本的ACE引擎。对于Access Runtime 2013，它是'Microsoft.ACE.OLEDB.15.0'。对于Office 2010，它是Microsoft.ACE.OLEDB.14.0。

A couple of things...

First, Which version of Office 2016 do you have installed? If it's the 32-bit version of Office, your application has to be compiled for a Platform Target of x86, NOT AnyCPU. Go into your Project Properties and click on the Build tab, you'll find it in there.

If you've got Office 2016 Click-To-Run installed, you have to install a separate Access runtime. Like above, you can either install the 2010 version or the 2013 version. It really doesn't matter. (If you try to install the 2016 version it'll tell you that you can't install it because you already have 2016 Click-To-Run installed.)

Once you have that install you have to change your connection string to use the correct version of the ACE engine. For the Access Runtime 2013, it's 'Microsoft.ACE.OLEDB.15.0'. For Office 2010, it's 'Microsoft.ACE.OLEDB.14.0'.

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