Authentication problem to MS SQL SERVER from MS ACCESS app

[roypython]

Hi.
I recently created SQL SERVER backend for my MS ACCESS app. (I upsized ONLY the tables, so the ACCESS app contains linked tables).

The SQL SERVER resides on a different machine than the MS ACCESS app.

Every time that I run the ACCESS app, it fails to connect to the SQL SERVER ("Login failed for user 'xxx'") and it prompts me for user name and password.
After I give it the right user name and password, no probs.

The problem is that ACCESS doens't save the new user name and password.
So every time that I run the app, again, it uses the wrong default user name and password (I don't know where it gets it from), and I need to re-enter the correct one.

HOw can I solve it?

Thank you very much
Roy

 

[Smart]

Try using windows authentication then you wont need to supply user name and password it will take the login information from the users windows login

 

[roypython]

Thanks for your reply.
The ACCESS app (which is front-end) will be distributed to tens of computers.
From that reason it will be easier to use one user name and password for all the front-end ACCESS app, then to insert all the computers' network-names into the SQL SERVER (so it'll work on windows login - or trusted connection).

 

[roypython]

Found a solution

http://www.utteraccess.com/forums/s...e=m&olderval=&oldertype=#Post673571&bodyprev=