Connecting Access 2003 with sql server

[Roy Goldhammer]

Hello there

I had Access97 application that work with sql server.

Now i pass to access 2003 and i have some problem

The access 2003 connection suddenly don't save password and any opening the
system require me to log on to access and to sql server

What changed on access 2003 that cause this problem?

any help would be useful

 

[mannix]

we have the same problem:
the access application forgets the user/password stored in the
dsn-connection-parameters and you have to re-enter it. this is very
disturbing as you have to enter it again for every linked object.

Has anybody a solution/hint for us how to fix this problem?

Thanks in advance!