ODBC connectivity logon's
 

Morning All,

I have a question to ask with regards to connection to ODBC links,

Excel all requires username/password authorisation everytime the same ODBC
link (query) is accessed.

Microsoft access only asks once then remembers from then on.

Is there a way to overcome the logon box in excel?

Thanks in advance

Jai