logworthy
logworthy

Reputation: 1258

How to use MS Access ODBC driver without installing it?

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

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

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

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.

Upvotes: 2

Views: 2502

Answers (1)

dom
dom

Reputation: 126

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. 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)

Upvotes: 4

Related Questions