如何在不安装的情况下使用 MS Access ODBC 驱动程序?

问题描述

直到今天，我们公司的工作站通常都安装了 MS Office ODBC 驱动程序:

Up until today our company workstations would typically have the MS Office ODBC drivers installed in:

C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE14

但是，由于某种原因，配置最近发生了变化，例如 Microsoft Access Driver (*.mdb, *.accdb) 现在指向:

However, for some reason the configuration recently changed so that for example Microsoft Access Driver (*.mdb, *.accdb) now points to:

C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE16

遗憾的是驱动的实际安装还在OFFICE14目录下.

Unfortunately the actual installation of the driver is still in the OFFICE14 directory.

有没有办法仍然使用这个驱动程序连接到 Access?

Is there any way to still use this driver to connect to Access?

我没有管理员访问权限，所以我正在寻找任何可能的解决方法，直到技术支持人员确认&解决问题.

I don't have admin access, so am looking for any possible work-around until tech-support acknowledge & resolve the issue.

推荐答案

不幸的是，这是不可能的.必须将驱动程序安装并注册为 ODBC 组件.到目前为止，我知道 3 种方法:

Unfortunately, this is not possible. The driver will have to be installed and registered as an ODBC component. So far, I am aware of 3 ways to do so:

1. 使用位于 \windows\system32\ 和 \windows\syswow64 中的 ODBCCONF.EXE.
2. 使用odbccp32.dll提供的SQLInstallDriverEx() API.
3. 手动创建注册表项(看看这个 SO 答案)

1. Use of ODBCCONF.EXE which resides in \windows\system32\ and \windows\syswow64.
2. Use of SQLInstallDriverEx() API provided by odbccp32.dll.
3. Manually create the registry keys (look at this SO answer)

这篇关于如何在不安装的情况下使用 MS Access ODBC 驱动程序?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！