Hi, I'm stuck with the following problem.
I want to connect a MS Access front-end to a Azure SQL backend. This works, but the user will get a popup to fill in the username and password at all times. I do not want to bother the user with this technical stuff. I insert the username and password with the connection string. If I use an ADO connection this works, but if I do a similar thing with a linked table it doesn't. After the user fills in the password it will remember it for the duration of the session. When he reopens the front end he has to manually login again.
My connection string looks like this:
Driver={ODBC Driver 17 for SQL Server};Server=tcp:myserver.database.windows.net;D atabase=MyDatabase;User Id=myusername;Password=mypassword;Encrypt=yes;Trus tServerCertificate=no;Connection Timeout=30;
Anybody has any hint for me?