Connector ODBC Password Prompt

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!
John AccountAsked:
Who is Participating?
 
CetusMODConnect With a Mentor Commented:
Closed, 250 points refunded.
CetusMOD
Community Support Moderator
0
 
UmeshMySQL Principle Technical Support EngineerCommented:
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

Hope this helps!
0
 
John AccountAuthor Commented:
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.
0
 
John AccountAuthor Commented:
I had to delete all the linked tables and relink 'em. That worked.
0
All Courses

From novice to tech pro — start learning today.