Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2019
    Location
    Netherlands
    Posts
    9

    MS Access can not remember an Azure SQL login

    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?

  2. #2
    NoellaG's Avatar
    NoellaG is offline Expert
    Windows 10 Access 2016
    Join Date
    Jun 2010
    Location
    Belgium
    Posts
    702
    Hi, I had some similar trouble in the past connecting Access to a regular SQL server, not Azure, and solved it by making the connection through a file dsn that was copied to each front end PC. However, this was some years ago. It has been a while since we used Access as a professional tool, mainly because everything was moved to the cloud and SAP.

  3. #3
    Gicu's Avatar
    Gicu is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    1,635
    Can you try to recreate the link and make sure you check the box for Save Password (refreshing the link won't work as that does not expose the checkbox)?
    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 09-08-2020, 01:34 AM
  2. ADO VBA and Azure SQL Server
    By nd0911 in forum SQL Server
    Replies: 2
    Last Post: 02-27-2019, 04:09 AM
  3. General discussion for MySQL, PHP, Azure
    By MrRuz in forum General Chat
    Replies: 2
    Last Post: 10-29-2014, 02:06 AM
  4. Access 2010 and SQL Azure
    By drexasaurus in forum SQL Server
    Replies: 2
    Last Post: 09-20-2012, 08:58 AM
  5. Access 2010 to SQL Azure migration
    By Aurelius7 in forum SQL Server
    Replies: 6
    Last Post: 06-18-2012, 10:15 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums - Senior Forums