SQL Server and Access

[Newbie]

Hi,

I have an access database (not project) that has three linked tables to 3
differenent SQL databases how can I get queries to work without the user
having to enter passwords for the SQL Server

 

[Newbie]

FYI - I have ODBC DSN's setup with the username and password. but this still
doesn't work

Is there a way of coding this so that the links can be refreshed, incl
passwords, without the need for user intervention?

 

[Ron Weiner]

Make sure that when you (re-)link the tables on the Sql Server that you
check the Remember Password checkbox. This will embed the password in the
link absolving that users from have to supply it each time they use the app.

Ron W

 

[Jim McDonald]

Try ADO connect programmatically.. password is one of the parameters.
Jimbo

 

[david epsom dot com dot au]

Also:

FYI - I have ODBC DSN's setup with the username and password. but this still
doesn't work

I think that means you haven't done that correctly ??? I think it is
supposed
to work

Is there a way of coding this so that the links can be refreshed, incl

Trusted connections (Win2K/WinNT security) is the easiest way.


(david)

 

[Newbie]

Thanks for all the replies - I just needed to check the Trusted Connection
box

Thanks again

Al