How to get linked table to login automatically to SQL7 using uid/pwd

R

Ross Culver

Ivan,

Delete your connections (links) and recreate them, only, this time check the
box that reads "Save Password" that's in the bottom right corner BEFORE YOU
CLICK "OK".

Ross
 
V

Van T. Dinh

You can set the Login data (LoginID & Password of the SQL Authentication) in
the DSN (ODBC driver).

Please adjust your computer time for next time.
 
I

Ivan Starr

Hello thank you for helping.

I have a few linked table in a msaccess97 frontend that I would like to
login to automatically using uid/pwd authentication (no domain). As it
stands now, there is a long pause while trusted authentication fails and the
login dialog appears when these linked tables are referred to in a form that
is opened or referenced in code for the first time, and that stinks.

So, if you could, please tell me how to get the darn linked tables to login
automatically and/or pre-empt the login process to the sql server using code
so as to avoid that unexpected and long timeout. I would be
super-appreciative.

Thanks,

Ivan
 
Top