In my previous post here, we discussed how to assign Office 365 permissions to Azure SQL databases. In this post, I will explain how to setup a ODBC connection with Access 2016. This post assumes you have already setup your Azure SQL database so you have the servername, username and password to login.
- Download and install Microsoft Online Services Sign-In Assistant from here
- Download and install the Microsoft ODBC Driver 13 for SQL Server from here. (At the time of this writing v13 was the latest one.)
- Start Microsoft Office Access 2016
- Click External Data from the Office ribbon then click ODBC Database
- Click Link to the data source by creating a linked table then click
- Click the Machine Data Source tab at the top then click New
- Select the data source type and click Next
- Click ODBC Driver 13 for SQL Server then click Next, then click Finish
- Specify the connection Name, Description, Azure SQL Server address, then click Next
- Click With Active Directory Password authentication using a login ID and password entered by the user, then enter in your Azure Active Directory Credentials and click Next
- Click Change the default database to: and specify a database and click Next. (Note: If you do not specify a database, it will not work
- Once the connection is tested, click OK – you should be prompted for your Azure AD credentials again to complete the connection
- You should now have a list pulled from Azure SQL which you can link