I have an application that's deployed at several location on windows
2003 servers. On each site it uses a distinct system dsn which contains
sa user and pswd, different for each site. Access ver 2000.
On on server, any time I call a passthrough query, I'm prompted for the
sa password. The linked tables present data without prompting for
password. I've removed and recreated the system dsn and the issue
persists.
All of the servers have the latest patches for windows 2003, and also
for sql server express. Why isnt' the password being retained by Access,
only for pass through queries?
