“当前未配置操作系统".Access ODBC错误 [英] "Operating system is not presently configured" error with Access ODBC
问题描述
当我尝试通过Python连接到Microsoft Access数据库时，出现以下错误.该代码一直在工作，直到今天才开始弹出错误.有人可以指导我现在可能出现什么问题吗?
I get the following error when I try to connect to Microsoft Access Database via Python. The code has been working all this time and only started popping the error today. Can someone please guide me what may be the problem occurring now?
下面是我如何使用Python连接到MS Access.
Below is, how I connect to MS Access in Python.
import pyodbc
conn = pyodbc.connect(r'Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=E:Folder\Database.accdb;')
错误:
当前未将操作系统配置为运行此应用程序.
The operating system is not presently configured to run this application.
推荐答案
我遇到了同样的问题，并解决了安装此Microsoft补充程序的问题:
I had the same issue and solved the problem installing this Microsoft complement:
https://www.microsoft.com/zh-CN-us/download/details.aspx?id = 54920
当您尝试安装它时，可能会给您带来一些问题.就我而言，我收到此消息:
It might give you some problems when you try to install it. In my case I had this message:
"您无法安装32位版本的Microsoft Access Database Engine 2016，因为您当前安装了64位Office产品...'
"You cannot install the 32-bit version of Microsoft Access Database Engine 2016 because you currently have 64-bit Office products installed..."
如果是这样，您可以尝试以下方法:
If so, you can try this:
- 按Win + R打开运行"窗口，键入安装程序"，然后单击Enter在File Explorer中打开文件夹.
- 添加主题"列.右键单击列标题，然后单击更多"并选择主题"
- 在主题"列上排序并向下滚动，直到找到名称"Office 16即点即用扩展组件64位注册".
- 右键单击MSI文件，然后选择卸载".
然后尝试重新安装.我不是专家，但对我有用.
And try to install it again. I'm not an expert but that worked for me.
参考文献:
https://social.technet.microsoft.com/Forums/en-US/76c99a6a-b809-4f50-8790-09c7c84f11af/failed-to-install-either-32bit-or-64bit-for-microsoft-access-database-engine-2016-redistributable?forum=officesetupdeployprevious (USER: Ray the DJ)
这篇关于“当前未配置操作系统".Access ODBC错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
