unwanted Sql Server Login

[RycherX]

When I set up my datasource to an SQLSERVER, I input username and pwd and successfully tested the connection.

After I open up a linked SQLSERVER table in access, I get the SQL Server Login box prompting me to input a password even though I had done that while setting my datasource.

I do not want go through the SQL Server Login box each time I open my MS Access.

 

[boblarson]

You need to relink them but this time check the box that says SAVE PASSWORD when you go to select your tables.

 

[namliam]

click the "remember password" box while creating the linked tables.

Edit: Bob got there before me

 

[RycherX]

Duh. It works now. Wonderful.