Access 97 - Win 7-64 - ODBC problem

[maddaze]

I have an Access 97 db that I've been using as the front end to a MySQL db, first under Win XP, then Win 7-32. I've just recently upgraded to Win 7-64 and I'm working my way thru the problems of getting everything to work together. And I'm stuck.

The 32-bit ODBC connection I created changes long varchar fields (over 255 chars) to Access text fields and queries containing those fields no longer work. Of course, these queries worked perfectly using ODBC under Win 7-32. Help!! I'd hate to lose the data in the long varchar fields.

Harvey in sunny Bordeaux

 

[maddaze]

Problem resolved: On the Win7-64 bit machine, I uninstalled all MySQL ODBC drivers, installed the 64-bit ODBC 3.51 driver, relinked the MySQL tables to the Access 97 database, and everything seems to work as before.

Harvey