I have an Access DB that utilizes linked tables from SQL. The DB has a login & Password for Read only access - let's say "login" "Password"
got the tables linked, built my queries and formed - everything works great.
Every time I reopen the Access Db, and a query looks at the Linked Tables - it gives a connection error:
Code:
Connection failed: SQLState:'2800' SQL Server Error: 18456 login failed for user
I choose okay, the login dialog comes up - but it is trying to use my network login "CDog"
I can change the user and login by unchecking "use trusted location"
It would be fine but several people are going to use this - I need a way for Access to log in as "login" "password" without having to re enter it all the time
Thanks