SQL Server with Access question

[Eric]

Hi. I am wondering if I can automatically put in a SQL
Server Username and Password for my DSN connection? Here
is my senerio.

I have already made a DSN connection to the SQL Server and
brought in all the tables I am going to use. When I close
out and open the .mdb at a later time, I am prompted for
the SQL Server username and password that the admin has
set up for me. It's only one time (actually everyime I
open the .mdb and click on either a table, query, form, or
report), but would like this automated. Is this possible?

 

[Alex Dybenko]

When you link table - you have an option to store password with connection
string. so try to relink tables with this option