How to install MS Access Database Driver 32 bit and 64 bit on a single machine

I want to have MS Access Database ODBC Driver 32 bit and 64 bit on my Windows 10 laptop. But unfortunately, the ordinary installation step will prevent to have both 32 bit and 64 bit driver on single machine. For example, if you have MS Access Database (or Office Suite) 32 bit installed, you cannot install the 64 bit ODBC driver on it. So, we need a trick to do this.

If you want to install Microsoft Database Engine 32 bit on a machine running MS Office 64 bit, you can do the following trick.

  • Download MS Database Engine 32 bit from this link. But please do not double click the file to install. It will fail.
  • Open Command Prompt and cd to the download directory. Then, install the file using this command instead:

AccessDatabaseEngine.exe/passive

Similar to it, if you want to install Microsoft Database Engine 64 bit on a machine running MS Office 32 bit, you can do the following:

  • Download MS Access Database Engine 64 bit from this link. Select the _x64 version and do not double click to install.
  • Open Command Prompt and use this command

AccessDatabaseEngine_x64.exe/passive

Follow on screen installation wizard and finally you will have both 32 bit and 64 bit MS Access Database Engine on your system. This trick works well on Windows 10 as well.

Admin

Leave a Reply

Your email address will not be published. Required fields are marked *