I have an MS Access 2000 application - with a fixed link to tables on an SQL server. I have set up a File DSN and choosen the "With SQL Server authorisation using a login ID and password supplied by the user" option.
However every time I want to use the application I get a " Connection failed;SQLm State '28000' SQL Server Error: 18456 login failed message - bacause the Login ID defaults to my network login ID. I can press ok at that stage and then remove tick from the trusted connection box and enter my SQL password but I don't want the user to have to do this every time they use the application.
Can someone tell me how I can get this to default to no trusted connection?