Connection to SQL DB

[eveCalypso]

Good Day All,
I use Access as a font-end only and linked SQL 2K tables as my back-end DB. My problem is that when the application starts up, this connection (maintained by Access) states that it does not have the username/password in the connectionString or a trusted connection to my SQL DB. I have setup a dsn string which does have a username/password in it, but somehow that makes no difference.

Once you filled out the SQL Server Login Screen (in my case all users will use the same SQL login), then the entire session runs ok until you exit the app.

Does anyone know what I can/must do to get rid of this screen? Can I somehow set the username and password via code for the connection Access creates and maintains internally before start-up? Or...?

Thank you so much in advance
Regards,
EvE
PS: If I am barking up the wrong forum please let me know ;-)

 

[PHV]

Have you checked the remember password when you linked the tables ?

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[eveCalypso]

Dear PHV,

I feel a right ninny now! That was exactly the problem. Thank you so much.

EvE