Okay, I've a couple last questions (for now...)
Why use SSMS as your development tool?
Is connecting to Azure SQL just a matter of rewriting the ODBC connection-string in the Access Link-manager?
Users now open Access and connect to the BE without a password required. Also, when in VBA a connection to the BE is opened, there's no pwd involved. Can this stay the same in this cloud environment?
Also, the string in VBA is
Code:
"Provider=Microsoft.Access.OLEDB.10.0;" & _
"Persist Security Info=False;" & _
"Data Source=servername;" & _
"Integrated Security=SSPI;" & _
"Initial Catalog=databasename;" & _
"Data Provider=SQLOLEDB.1"
and is used in all ADODB connections. Will there be any substantial changes there?