Need to save SQLdatabase userid & password after link has been cre
 

Hello,

Not sure if this is the right group or not, but here goes my question:

I've set up an SQL query from excel and everything works great. Everytime I
need to update the data, it asks for userid & password. The userID is
remembered.

Now that I'm automating the update of the table with a macro, I'm in need of
having the userID & password saved so that when the macro is ran (at night)
the macro doesn't hang because the userID & password window pops up. Do you
know of an option to save the database password so that it doesn't pop up
that window?

If I can't go into some settings to make it save the password, can I have
this done in the VB macro? What does the code look like?

thanks in advance!