By default, Windows prevents installing 64-bit drivers if 32-bit Office components are present. To bypass this and install both, follow these steps: SQLServerCentral Download the installer AccessDatabaseEngine_X64.exe ) to a known folder like C:\Downloads Open Command Prompt as an Administrator. Run with the /passive switch : Type the full path to the installer followed by and hit Enter. C:\Downloads\AccessDatabaseEngine_X64.exe /passive Registry Cleanup (If Needed) : If you still face issues, you may need to delete the registry value under
Open (located at C:\Windows\SysWOW64\WindowsPowerShell\v1.0\powershell.exe ) and run the same script.
By default, Microsoft prevents side-by-side installation because both installers register the same CLSIDs. However, there is an officially supported workaround: .
You can download the Microsoft.ACE.OLEDB.12.0 provider by installing the Microsoft Access Database Engine 2016 Redistributable