Hello - my company has migrated some DBs to Azure and I want to update the DAO connection string in VBA. Suggestions for string formats that work well please? Thanks. I was trying the string(s) below for example but I get error 3170 installable ISAM error?
Code:
gsConnectionDB = "Provider=MSOLEDBSQL;Data Source=SERVER;Initial Catalog=DATABASE;Connect Timeout=0;Authentication=ActiveDirectoryIntegrated;Use Encryption for Data=true"
gsConnectionDB = "Server=SERVER; Authentication=Active Directory Integrated; Encrypt=True; Database=DATABASE;"