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