Office TechCenter >
Office 2010 Forums
>
Microsoft Office 2010 Tech Preview
>
Access 2010 64 bit and 32 bit ODBC
Access 2010 64 bit and 32 bit ODBC
- Running Windows 7 64 Bit and Office 2010 64. I uninstalled Office 2007 prior to installing 2010. I'm wondering if I can use Access 2010 to connect to my previous 32 bit data sources. I am able to set them up in the 32 bit ODBC managment app and use them with Access 2007 32, but can't browse to them at all via Access 2010. ( I do see the 64 bit connections in Access).
Wouldn't suprise me if this was not possible. Just looking to confirm or for a workaround so I can avoid having 2007 and 2010 on the machine. Thanks!
All Replies
It is so typical of Microsoft to put the 64 bit drivers in the System32 folder and the 64bit drivers in a folder called SysWOW64. The other issuer I had with ODBC drivers failing to connect was because of the naming convention of the Program Files (x86) folder. Apparently some ODBC drivers like the Microsoft ODBC for oracle driver apparently do not like special characters like parenthesis. I had to uninstall my Office 2007 and reinstall it to a folder in the c:\ directory to get ODBC working in Access.
