I have a problem using an ODBC Connection linking an Access Database to a remote ISP Database. Firstly, let me say the connection runs fine on a laptop running Vista but when I try on a laptop running Windows 7 I get an error.
The ODBC Connector created in Access works OK on both machines, and I can see the data in the tables if I open them by double clicking. I only get the error when I run a form using VBA on the Windows 7 machine and I get the following error when running a form:-
ODBC - call failed
[MySQL][ODBC 5.2(w) Driver][mysql 5.0.51a+lenny5log]Server does not support 4-byte encoded UTF8 characters (#)
I cannot understand how the same ODBC script can run on 1 machine but not another. The link has been made OK but the VBA does not work?
Could anyone shed some light on this?
The ODBC Connector created in Access works OK on both machines, and I can see the data in the tables if I open them by double clicking. I only get the error when I run a form using VBA on the Windows 7 machine and I get the following error when running a form:-
ODBC - call failed
[MySQL][ODBC 5.2(w) Driver][mysql 5.0.51a+lenny5log]Server does not support 4-byte encoded UTF8 characters (#)
I cannot understand how the same ODBC script can run on 1 machine but not another. The link has been made OK but the VBA does not work?
Could anyone shed some light on this?
