Posted by aspsql on 10/01/79 11:38

I have a website which runs off a Access database which I am currently
converting to sql server database. I would like to still use my access
front end for reporting and queries..
I created an odbc connection on my computer to the remote sql server
and created a link in access to my sql server tables. All my report and
Queries run fine I just have one problem it keeps on prompting me for
ther password of the remote sqlserver database. I check the odbc
connection and I see the password is not saved in there even though I
put it in. Is there a way I can have the password saved. I do not want
keep on having to enter the password.

[Back to original message]