Install 64-bit ACE.OLEDB Download Microsoft Access Database Engine 2010 with 32-bit Office

1. Download Microsoft Access Database Engine 2010 Redistributable here
2. Install the version you need. I have 32-bit Office and a 64-bit PC using Windows 7 so had to do this to avoid the error about uninstalling Office:
3. AccessDatabaseEngine_X64.exe /passive
4. And it worked!

EDIT:

But it also now creates a problem whenever an OFFICE document is opened. Here’s a solution, although I had to add the “NoReReg REG_DWORD 1” myself in HKCU\Software\Microsoft\Office\14.0\Word\Options
Microsoft Office 2010 Professional Plus configures each time you start