SQL Server and Access

  • Thread starter Thread starter Newbie
  • Start date Start date
N

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
 
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?
 
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
 
Also:

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

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
Click to expand...

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


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

Thanks again

Al
 
Back
Top