Log into server tables in MS Access app

[hardrock]

i'm totally new to SQL so please bear with me!

I've basically linked some tables from my works SQL server to my Access application. Everytime i exit my Access app and go back into it, a dialog box come up asking me to enter username and password for the server, which i enter and it gives me full access!

My quesion is, how can i automate the login procedure using code when my form loads. Many thanks!

 

[pbaldy]

One option is to link the tables again, but check the box that asks if you want to save the password.