Office XP on Windows 7 64 ODBC not linked
Posted on 2010-11-30
Ever since 2002 I have been developing on Office XP developer edition and still have quite a few databases running Access XP front ends with either SQL Server or MySQL backends. Converting them all is not an option.
I recently moved my main machine to Windows 7 64bit and so far everything seemed to work, until now.
I can open up the ODBC control panel and create a connection to my server (Server 2008) which has both SQL Express 2008 and MySql 5.x on it, connections here to both are fine. I can open the MySQL query browser on my Win7 machine and execute queries on the server just fine. Now when I open Access XP's linked tables dialog the ODBC connections I entered in the Windows 7 control panel are not there. When I create a new one in Access pointing to the SQL Server it works fine but it does not show up in the Windows 7 ODBC control panel.
This may not be an issue, or it may be. Since the end user will have an Access runtime instead of a full blown copy they will not have a way to set up a ODBC connection unless they can do it from the Windows ODBC control panel.