So I’ve had a little problem. I needed to open an Access Database in RStudio. Sounds easy right? Well the problem was that I have MS Office 2007 along with the default OBDC drivers, these are 32bit. I’m also using R and RStudio 64bit. They don’t work well together.
I looked for the 64 bit driver and found it here: Microsoft Access Database Engine 2010 Redistributable.
The next problem is, it doesn’t look like you can install this whilst you have Office 2007 installed. I read you can uninstall Office 2007, install the new driver and then re-install Office 2007.
I didn’t try that, I simply ran the new installer from command prompt with the /passive argument.
How to install without messing about…
- Download the driver above.
- Open up command prompt, ctrl+r then type cmd.
- Use dir to navigate to where you downloaded the driver.
- Type “AccessDatabaseEngine_x64.exe /passive” (without quotes) and hit Enter.