<div>
Hi,<br />
<br />
Check this..<br />
While doing DSN configuration you have a option , just click on that..then &nbsp;you would see something like &nbsp; &quot;&nbsp;DOn't prompt on connect&quot; in the miscellaneous optons [Rarely Used] &nbsp;just make sure that the checkbox is checked.<br />
<br />
just check out this url for more..<br />
<a href="http://www.sourcekeg.co.uk/www.mysql.com/doc/connector/odbc/en/faq_3.html" rel="ugc">http://www.sourcekeg.co.uk/www.mysql.com/doc/connector/odbc/en/faq_3.html</a><br />
<br />
Hope this helps!
</div>


Hi,

Check this..
While doing DSN configuration you have a option , just click on that..then  you would see something like   " DOn't prompt on connect" in the miscellaneous optons [Rarely Used]  just make sure that the checkbox is checked.

just check out this url for more..
http://www.sourcekeg.co.uk/www.mysql.com/doc/connector/odbc/en/faq_3.html [http://www.sourcekeg.co.uk/www.mysql.com/doc/connector/odbc/en/faq_3.html]

Hope this helps!

<div>
Have tried that myriad times--it never retains its value. &nbsp;That &quot;Don't Prompt On Connect&quot; option is useless, or it means something else. <br />
At any rate, it doesn't work. Thanks.
</div>


Have tried that myriad times--it never retains its value.  That "Don't Prompt On Connect" option is useless, or it means something else.
At any rate, it doesn't work. Thanks.

<div>
I had to delete all the linked tables and relink 'em. That worked.
</div>


I had to delete all the linked tables and relink 'em. That worked.

<div>
<div class="content wysiwyg-content">
I'm using MS Access 2002 as a front-end to MySQL. &nbsp;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. &nbsp;Is there an Expert here that knows how to get this connector window to stop prompting me? &nbsp;Yes the password is stored in my system dns.<br />
<br />
What do I need to do on the MySQL Server to prevent this prompt from occurring? Many kind thanks in advance!
</div>
</div>


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!

Connector ODBC Password Prompt

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.