I'm using MS Access 2002 as a front-end to MySQL. I don't want to be prompted for the password by the Connector/ODBC Window everytime I use open my Access database. I don't know why it doesn't it retain my password. Is there an Expert here that knows how to get this connector window to stop prompting me? Yes the password is stored in my system dns.
What do I need to do on the MySQL Server to prevent this prompt from occurring? Many kind thanks in advance!