MS Access 2010 TLS 1.2 Data link error RRS feed

  • Question

  • Hi,

    We have a legacy application in MK Access 2010 and recently we have upgraded our TLS policy

    The connection properties are defined in data link properties 

    File > Info > Server > SQL server name and database

    I need to update the connection string.... where is this information stored in MS Access? anyone any idea?

    Error details because of TLS 1.2 upgrade

    I want to change the connection string to this

     "provider=SQL Server Native Client 11.0;integrated security = sspi;data source=" & ServerName & ";initial catalog=" & DatabaseName

    Thanks for the help...

    • Edited by StSingh Tuesday, August 11, 2020 8:47 AM
    Monday, August 10, 2020 8:46 PM

All replies

  • The following was written for A2007 but the code should apply in your situation. 


    That being said, I am doubtful you'll be able to use SQL Server Native Client 11 with an Access ADP.  Please post here if you have any success.

    Thursday, August 13, 2020 5:08 PM