Hi,
I have a local user on our network running MS Access 2003 (on Win XP
Home), which needs to connect to a Back-End MySQL DB on our Cobalt
Qube 3 Server.
I installed the correct software to run the Access on their Win XP OS,
and installed the ODBC MySQL Driver 3.51.
When I test the connection in the ODBC panel, CONNECTED !
Then I open MS Access, and great, the app works.
If I then close MS Access and re-open, as soon as I hit a button which
needs data from MySQL then I get an error stating that this IP cannot
connect to the MySQL DB using Password (Yes). I have tried taking the
password out of the DSN, and user account for MySQL, but this makes no
difference.
After the second time trying to open MS Access, it brings up the ODBC
Admin panel, and I have to delete the password and try to connect,
'connection failed', then enter the password 'connected!'. If I then
open Access it runs, if I then exit & re-start the app 'Cannot connect
using IP........., using Password...)
I have double checked all the settings in the DSN, and their user
account for the MySQL DB.
Surely, the PC should be able to connect either all the time, or not
at all, not just once, and then lose the connection ????
Can anyone help me on this ?
Thanks
David.
