I am setting up a WinXP PC with the MySQL odbc driver to connect using MS Access to my MySQL database.
It is hosted on a Linux server at present.
I can connect successfully, at least when I use the test facility on the odbc driver confguration page, but I get an HY000 user cancelled error when I actually try to link to any of the tables in it.
Any suggestions ?
Thanks in advance