I have already written on many levels 100 developer's articles on SQL Azure. You can read them here. I thought that if my SQL Azure blog post series does not have a post on "Connecting SQL Azure to Microsoft Access" then it cannot be called a complete post series. So I gave a try and came up with this article. Before you start reading this step by step walkthrough, I request that you first read some of previous articles on SQL Azure hereAs in my other SQL Azure article, I am going to connect to the School Database again. To connect Microsoft Access with the SQL Azure School database follow the steps below.
Fixing Error: "SetConfigurationSettingPublisher needs to be called before FromConfigurationSetting can be used"
Fixing error: SetConfigurationSettingPublisher needs to be called before FromConfiguration Setting can be used