Connecting Microsoft Access to SQL Azure

I have already posted on many level 100 developers articles on SQL Azure. You can read them here. I thought if my SQL Azure blog post series does not have a post on “Connecting SQL Azure to Microsoft Access “then it cannot be called as complete post series. So I gave a try and came up with this blog post. Before you start reading this step by step walkthrough, I request you to first have a read on some of previous blog posts on SQL Azure here

As my other SQL Azure post, I am going to connect School Database again. To connect Microsoft Access with SQL Azure School database follow the steps as below.

1. Open Microsoft Access and create a blank Database.


2. Click on the Create button in left to create a blank database.


3. From top select External Data and ODBC Database option


4. Select the second radio button.


5. New panel will come to select Database server name.


6. Click on New and you will pop up with a new panel. To connect with SQL Azure select SQL Server Native Client 10.0


7. Click on Advanced option. Here you need to give ODBC connection string to SQL Azure Database. Login to SQL Azure portal and copy paste ODBC connection string here

To get connection string, select Database and at right in the property you will get Connection string.


Copy ODBC connection string from here,


Copy paste ODBC connection string in this panel after selecting advanced option.


8. Click on ok and give a name to connection. I am giving name abc.


Click next and select Finish. You will prompt with new panel as below

9. Uncheck Use Trusted Connection check box. Provide password and click OK


10. Oh My God and here you are, you have all the tables from SQL Azure Database listed to select in Microsoft Access.


Few points you need to cross check

1. See the Firewall rules of SQL Azure Database server.

2. Edit the Firewall rule range to cover IP address of your client machine.

3. Check SQL Server 2008 R2 native client is installed on your client machine.

4. While copying ODBC Connection string, you have changed the password.

Thanks , I hope this post was useful.

8 responses to “Connecting Microsoft Access to SQL Azure”

  1. […] Connecting Microsoft Access to SQL Azure (Dhananjay Kumar) […]

  2. Connecting Microsoft Access to SQL Azure « DEBUG MODE………

    Thank you for submitting this cool story – Trackback from DotNetShoutout…

  3. […] Connecting Microsoft Access to SQL Azure « DEBUG MODE…… […]

  4. that’s great for connecting to the master database which is easy. what about a database that is not the master? that’s what I can’t get to work.

  5. To connect to a specific database.

    Step 7,

    **if in the SQL Azure web portal you navigate go to your database and click ‘Show connection strings’ then the connection string will already contain the parameter for that database, but anyhow make sure the connection string has this in it, see below


    replace mydb with the name of your database.. don’t miss the semi column at the start, as parameters are separated by these..

  6. Best instructions I have found on the web so far. Thanks. Why is it so impossible for MS to provide simple, step-by-step instructions?

  7. I have the tables linked and I see them. When I open the tables to see the data all the rows show #deleted#, which scared me. I went into sql just to make sure my data wasn’t deleted and it was all there. Does anyone know why the data might not be showing? It looks like it has the correct amount of rows in each table.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Create a website or blog at