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

message from Ivan Starr on 3 Jun 2004

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

=?Utf-8?B?Um9zY28=?= replied to Ivan Starr on 3 Jun 2004

1. Rename the tables you currently have linked.
2. Create a new link to the database using the odbc dsn ( data source name).
3. Log in using the uid/password you wish to save.
4. Select the tables you wish to link an Check the Save Password check box.

The next time you access those linked tables, you should not be bothered by the log in dialog.
Of course your company may have added security. I can't answer to that.

5. If all works delete the tables you renamed.

Hope this helps
Rosco

Ross Culver replied to Ivan Starr on 3 Jun 2004

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

"Ivan Starr" <ivan@ivanstarr.com> wrote in message
news:%23eUoEuZSEHA.504@TK2MSFTNGP11.phx.gbl...

Van T. Dinh replied to Ivan Starr on 4 Jun 2004

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.

Archived message: How to get linked table to login automatically to SQL7 using uid/pwd (Microsoft Access Database)