By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,851 Members | 1,183 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,851 IT Pros & Developers. It's quick & easy.

I am unable to connect to an SQL Azure database through OBDC in Access. What am I do

P: 2
I created and uploaded data to an Azure SQL database. But, when I go into the Access database and try to connect to this SQL database, I get the following message:
"You cannot use ODBC to import from, export to, or link to an external Microsoft Access or ISAM database table to your database." What am I doing wrong?
Mar 6 '14 #1

✓ answered by zmbd

An update to this:
While searching for an unrelated issue I came accross this article written by one of the MVPs;
http://www.devhut.net/2014/01/
Scroll down a ways, you will find a step by step to accomplish the connections via O360; however, I can not immagine that this information can't be used somehow with ACC2007/2010/2013

Share this Question
Share on Google+
3 Replies


zmbd
Expert Mod 5K+
P: 5,331
You haven't provided your code so we are unable to provide specfics; however, it is possible for ACC2010 to connect using standard ODBC to Azure. Please read and follow the instructions here for the most basic method;
Access 2010 and SQL Azure by Access Team, on June 7, 2010
Mar 6 '14 #2

zmbd
Expert Mod 5K+
P: 5,331
An update to this:
While searching for an unrelated issue I came accross this article written by one of the MVPs;
http://www.devhut.net/2014/01/
Scroll down a ways, you will find a step by step to accomplish the connections via O360; however, I can not immagine that this information can't be used somehow with ACC2007/2010/2013
Mar 13 '14 #3

P: 2
Finally! At least there is hope for finding a solution! Thank you so much for posting the link to this article. Looks like I'm going "hybrid."
Mar 21 '14 #4

Post your reply

Sign in to post your reply or Sign up for a free account.