Managing DSN less connections, new credentials

T

tobiyas

Joined
Jan 11, 2010
Messages
2
Reaction score
0
I've set up my Access front-end to connect to MySQL using Dougs DSN-less method http://www.accessmvp.com/DJSteele/DSNLessLinks.html

The problem I'm having, is I am trying to run the code again to use different username and password. The code runs with no errors but the linked table still uses the old username and password.

I think its something to do with the way it saves the password the first time its run but I'm not sure how to fix. Any help would be great.
 
Just an update. When I try the code using a different database name, the new user credentials are used. So its seems to be a problem refreshing or updating the connection string when only the user/pass is changed.
 
Back
Top