Re: How to avoid connection popup?
- From: "Justin Hoffman" <j@xxxxx>
- Date: Thu, 26 May 2005 09:26:29 +0000 (UTC)
"Hallgeir" <hallremovegeir@xxxxxxxxxxxxx> wrote in message
news:sjgle.1078$qE.232841@xxxxxxxxxxxxxxxxxx
>I have an access application with linked odbc tables to a "ms sql server
>2000" database.
> Everytime we start the access app and try to use it the connection dialog
> pops up an the users have to type in user name and password. When this is
> done the access app workes fine until the next time we start it.
> My questions is: Is there a way to read the necessary link information
> from a given linked tabel and then use this information to refresh the
> connection in a way so that the users don't have to see and relate to the
> connection popup? And can someone give example or hints on how to write
> code to perform such a task?
>
> Thanks!
> --
> mvh
> Hallgeir
The best way would be to use Wiindows integrated security - this is where
you have SQL logins which correspond to Windows user accounts. Since you
have already logged on to Windows, you do not need to log on again to SQL
Server. Ask the administrator to set this up for you.
If this is not possible, then there are other ways but these may pose a
security risk as you basically want to by-pass the login mechanism. If you
are not worried about this then you can save the password with the linked
table when you create the links.
.
- Follow-Ups:
- Re: How to avoid connection popup?
- From: Hallgeir
- Re: How to avoid connection popup?
- References:
- How to avoid connection popup?
- From: Hallgeir
- How to avoid connection popup?
- Prev by Date: BINARY_CHECKSUM
- Next by Date: Re: ntext problem with text box control
- Previous by thread: How to avoid connection popup?
- Next by thread: Re: How to avoid connection popup?
- Index(es):
Relevant Pages
|
