blocks|key|449438|text|我突然想到检查每个提供程序使用的文件版本，并在注册表中查找，发现在安装了Office+2013的全新Windows+8安装下，两个提供程序都指向相同的程序集。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|449439|(C:\Program+Files\Common+Files\microsoft+shared\OFFICE15\ACEOLEDB.DLL)|449440|然后，我下载并运行了Microsoft+Access数据库引擎可再发行程序(http://www.microsoft.com/en-us/download/details.aspx?id=13255)，该程序随后将12.0提供程序的正确版本安装到C:\Program+Files\Common+Files\microsoft+shared\OFFICE14\ACEOLEDB.DLL中，应用程序运行正常。|offset|length|449441|这似乎很奇怪，微软已经包括了一个品牌为12.0的提供商，它的行为不再像12.0了。|449442|无论如何-希望这能帮助那些4-5个小时的头发拉扯的人…|449443|克雷格|449444|entityMap|0|LINK|mutability|MUTABLE|url|http://www.microsoft.com/en-us/download/details.aspx?id=13255^0|0|0|12|1P|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|V|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|W|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|X|8|@]|9|@$F|Y|G|Z|1|10]]|A|$]]|$1|H|3|I|5|6|7|11|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|12|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|13|8|@]|9|@]|A|$]]|$1|N|3|-4|5|6|7|14|8|@]|9|@]|A|$]]]|O|$P|$5|Q|R|S|A|$T|U]]]]

It occurred to me to check the versions of files being used for each provider, and hunting through the registry, found that under a clean Windows 8 install, with Office 2013 installed, both providers point to the same assembly.

(C:\Program Files\Common Files\microsoft shared\OFFICE15\ACEOLEDB.DLL)

I then downloaded and ran the Microsoft Access Database Engine Redistributable (<a href="http://www.microsoft.com/en-us/download/details.aspx?id=13255" rel="noreferrer">http://www.microsoft.com/en-us/download/details.aspx?id=13255</a>) which then installed the proper version of the 12.0 provider into C:\Program Files\Common Files\microsoft shared\OFFICE14\ACEOLEDB.DLL and the application is behaving itself as expected.

It would seem strange that MS have included a provider branded as 12.0 that doesn't behave like 12.0 any more.

Anyway - hope that helps someone from 4-5 hours of hair pulling...

Craig

blocks|key|5205963|text|此外，32位版本的Redistributable似乎适用于64位Windows+OS上的Office，而64位版本的Redistributable在我的情况下不能|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5205964|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

In addition, it seems the 32 bit version of the Redistributable works for Office 2013_64 bit on a 64bit Windows OS whereas the 64 bit version of the Redistributable didn't in my case

blocks|key|450267|text|只是为了澄清OP所描述的行为：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|450268|对于Office+2013+(ACE+15.0)，Microsoft取消了对使用Jet+3.x和更早版本(即Access+97和更早版本)创建的mdb文件的支持。因此，我强烈假设导致问题的OP数据库是Access97-DB。Jet4.0数据库(Access+2000和.mdb)仍然受支持，不会产生任何错误。|450269|Office+2013也将其较新的驱动程序注册为较早的版本，这是MS故意尝试保持许多程序和脚本正常运行的事实，这些程序和脚本具有内置的硬编码提供程序名称。正如你在升级时认识到的那样，这只是让many工作，而不是...|offset|length|style|BOLD|450270|entityMap^0|0|0|2N|4|2X|3|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|M|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|N|8|@$F|O|G|P|H|I]|$F|Q|G|R|H|I]]|9|@]|A|$]]|$1|J|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|K|$]]

Just to clarify the behavior described by OP:

With Office 2013 (ACE 15.0) Microsoft cancelled support for mdb-Files created with Jet 3.x and before (that is, Access 97 and earlier). I therefore strongly assume that the OP's database that caused the problem was an Access97-DB. Jet 4.0 databases (Access 2000, aslo .mdb) are still supported and will not produce any errors.

The fact that Office 2013 also registers its newer drivers as earlier versions is a deliberate attempt from MS to keep many programs and scripts working, that have a hard-coded provider name built in. As you recognized on your upgrade, this only keeps many working, not all...

blocks|key|4723205|text|我正在使用微软Windows8.1+64位和微软Office2013我安装了"Microsoft+Access+Database+Engine+2010+Redistributable"，但没有任何变化，并且得到了相同的错误，但是！安装“2007Office+System+Driver:+Data+Connectivity+Components"解决了这个问题。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|4723206|我通过这个link找到了这个解决方案。|4723207|4723208|尝试连接到visual+studio中的Access数据库，但一直收到此错误？|blockquote|4723209|4723210|先试着安装这个：http://www.microsoft.com/download/en/details.aspx?id=13255|4723211|但是，如果像我一样，这对你不起作用，请尝试以下方法：|4723212|注意:这确实适用于office+2010，尽管它适用于2007年的office，但请不要问我为什么它只是这样:)|4723213|4723214|数据源下载并安装：http://www.microsoft.com/download/en/confirmation.aspx?id=23734|4723215|in+VS单击add+|unordered-list-item|4723216|，按照向导操作并享受！:)|ordered-list-item|4723217|4723218|4723219|entityMap|0|LINK|mutability|MUTABLE|url|http://social.msdn.microsoft.com/Forums/en-US/1d5c04c7-157f-4955-a14b-41d912d50a64/how-to-fix-error-the-microsoftaceoledb120-provider-is-not-registered-on-the-local-machine?forum=vstsdb|1|http://www.microsoft.com/download/en/details.aspx?id=13255|2|http://www.microsoft.com/download/en/confirmation.aspx?id=23734^0|O|A|12|1J|3A|1K|0|5|4|0|0|0|0|0|8|1M|1|0|0|0|0|9|1R|2|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|1F|8|@$9|1G|A|1H|B|C]|$9|1I|A|1J|B|C]|$9|1K|A|1L|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|1M|8|@]|D|@$9|1N|A|1O|1|1P]]|E|$]]|$1|H|3|-4|5|6|7|1Q|8|@]|D|@]|E|$]]|$1|I|3|J|5|K|7|1R|8|@]|D|@]|E|$]]|$1|L|3|-4|5|6|7|1S|8|@]|D|@]|E|$]]|$1|M|3|N|5|6|7|1T|8|@]|D|@$9|1U|A|1V|1|1W]]|E|$]]|$1|O|3|P|5|6|7|1X|8|@]|D|@]|E|$]]|$1|Q|3|R|5|6|7|1Y|8|@]|D|@]|E|$]]|$1|S|3|-4|5|6|7|1Z|8|@]|D|@]|E|$]]|$1|T|3|U|5|6|7|20|8|@]|D|@$9|21|A|22|1|23]]|E|$]]|$1|V|3|W|5|X|7|24|8|@]|D|@]|E|$]]|$1|Y|3|Z|5|10|7|25|8|@]|D|@]|E|$]]|$1|11|3|-4|5|6|7|26|8|@]|D|@]|E|$]]|$1|12|3|-4|5|6|7|27|8|@]|D|@]|E|$]]|$1|13|3|-4|5|6|7|28|8|@]|D|@]|E|$]]]|14|$15|$5|16|17|18|E|$19|1A]]|1B|$5|16|17|18|E|$19|1C]]|1D|$5|16|17|18|E|$19|1E]]]]

I'm using Windows 8.1 64bit and Microsoft Office 2013
I Installed "Microsoft Access Database Engine 2010 Redistributable" but Nothing Changed and a got the same error BUT !
Installing the "2007 Office System Driver: Data Connectivity Components" solved the Problem.

I found this solution through this <a href="http://social.msdn.microsoft.com/Forums/en-US/1d5c04c7-157f-4955-a14b-41d912d50a64/how-to-fix-error-the-microsoftaceoledb120-provider-is-not-registered-on-the-local-machine?forum=vstsdb" rel="nofollow">link</a>.

<blockquote>
 trying to connect to an Access database in visual studio but keep
 getting this error?
 
 try installing this first:
 <a href="http://www.microsoft.com/download/en/details.aspx?id=13255" rel="nofollow">http://www.microsoft.com/download/en/details.aspx?id=13255</a>
 
 however if, like me, that doesnt work for you, try the following
 method:
 
 NOTE: this DOES work for office 2010 even though it is for 2007
 office, dont ask me why it just does :)
 
 <ol>
 <li>download and install this: <a href="http://www.microsoft.com/download/en/confirmation.aspx?id=23734" rel="nofollow">http://www.microsoft.com/download/en/confirmation.aspx?id=23734</a></li>
 <li>in VS click add data source, follow the wizard and enjoy! :)</li>
 </ol>
</blockquote>

blocks|key|450346|text|安装较旧的Access的问题是，下次在Office2013中运行Access时，Office将“修复”自己，并将版本12的指针切换回Office15目录。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|450347|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

The problem with installing the older ACE redistributable is that the next time you run Access in Office 2013, Office will "repair" itself and switch the pointer for version 12 back to the Office15 directory.

blocks|key|450358|text|type|unstyled|depth|inlineStyleRanges|entityRanges|data|450359|安装Microsoft+Access数据库引擎2010+Redistributable+x+64(http://www.microsoft.com/en-us/download/details.aspx?id=13255)|ordered-list-item|offset|length|450360|convert您的数据库为新格式(.mdb+->+.accdb)|450361|在整个项目中搜索"Microsoft.Jet.OleDb.4.0“并将其替换为Microsoft.Jet.OleDb.4.0|450362|450363|entityMap|0|LINK|mutability|MUTABLE|url|http://www.microsoft.com/en-us/download/details.aspx?id=13255^0|0|1D|1P|0|0|0|0|0^^$0|@$1|2|3|-4|4|5|6|S|7|@]|8|@]|9|$]]|$1|A|3|B|4|C|6|T|7|@]|8|@$D|U|E|V|1|W]]|9|$]]|$1|F|3|G|4|C|6|X|7|@]|8|@]|9|$]]|$1|H|3|I|4|C|6|Y|7|@]|8|@]|9|$]]|$1|J|3|-4|4|5|6|Z|7|@]|8|@]|9|$]]|$1|K|3|-4|4|5|6|10|7|@]|8|@]|9|$]]]|L|$M|$4|N|O|P|9|$Q|R]]]]

<ol>
<li>Install Microsoft Access Database Engine 2010 Redistributable x 64(<a href="http://www.microsoft.com/en-us/download/details.aspx?id=13255" rel="nofollow">http://www.microsoft.com/en-us/download/details.aspx?id=13255</a>)</li>
<li>convert Your data base to new format (.mdb -> .accdb)</li>
<li>Search entire project for "Microsoft.Jet.OleDb.4.0" and replace it by Microsoft.ACE.OLEDB.12.0</li>
</ol>

I have an x64 application which uses Microsoft.ACE.OLEDB.12.0 provider to read an MS Access Database on Windows 7 (x64) and it works fine (Office 2010 installed).

The same application running under Windows 8 with Office 2013 installed, fails with a message saying that the provider cannot open previous versions.

Under Windows 8 with Office 2013 installed, there is also Microsoft.ACE.OLEDB.15.0, but I have double checked my code and certain that it is specifying the 12.0 in the connection string.

Are there different "versions" of this provider -or is there something I've missed?

I have recompiled a test program under Windows 8 for using x86 platform, and changed the provider to Microsoft.Jet.OLEDB.4.0 and it all works again. Unfortunately, the module is part of a bigger ecosystem that needs to be able to be run under x64 (specifically an plug in to excel), and the access database is downloaded by the suite from a supplier's web site by the application, so it is not practical to convert the database or change everything to x86.

Thanks in advance.

Microsoft.ACE.OLEDB.12.0 Provider can no longer open .mdb under Windows 8

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我有一个使用Microsoft.ACE.OLEDB.12.0提供程序在Windows7 ( x64 )上读取MS Access数据库的x64应用程序，它工作正常(安装了Office2010)。在安装了Office 2013的Windows 8下运行的同一应用程序失败，并显示一条消息，指出提供程序无法打开以前的版本。在安...

问Microsoft.ACE.OLEDB.12.0提供程序无法再在Windows8下打开.mdb
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Microsoft.ACE.OLEDB.12.0提供程序无法再在Windows8下打开.mdbEN