MS-Access 2007/2010/2013 ODBC 32-bit connector to MySQL 64-bit Server on W-7 localhost?
I have a MS Access report application that connects to a MySQL database using ODBC with SELECT privileges only. On my Windows XP machines this has never been a problem. It was 32 bit all the way. 32-bit versus 64-bit was never an issue. But making it work from MS-Access 2007/2010/2013 using a 32 bit connector to a 64-bit server has become a problem. I had this working at one time in MS-Access 2007. Now that doesn't work either. I must of messed something up and don't know what it is. I have attached 5 JPG screen shots to show what I am getting. I hope somebody has a solution for this problem.