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

[sdcoates]

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?

[zmbd]

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

[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

[sdcoates]

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."

[cetpainfotech]

If you're unable to connect to an SQL Azure database through ODBC in Microsoft Access, there are a few steps you can take to troubleshoot the issue:

1. Verify the ODBC Driver: Make sure that you have the latest version of the Microsoft ODBC Driver for SQL Server installed on your computer.

2. Check the Connection String: Verify that you have entered the correct connection string in Access. The connection string should include the server name, database name, and any necessary credentials.

3. Firewall Settings: Ensure that the firewall settings on your SQL Azure database allow incoming connections from the IP address of the computer you're using Access on.

4. Check the Status of SQL Azure: Make sure that your SQL Azure database is running and accessible. You can check the status of your database in the Azure portal.

5. Try a Different Connection Method: If you're still unable to connect to the SQL Azure database, try connecting using a different method, such as the SQL Server Management Studio.

6. Get Support: If you continue to have issues, you may want to reach out to Microsoft support for additional help.

These are some of the common steps you can follow to resolve the issue of connecting to an SQL Azure database through ODBC in Microsoft Access.

If you're looking to build your skills in Microsoft Azure, CETPA Infotech is the perfect place to start. With its comprehensive training programs, expert instructors, and hands-on approach to learning, CETPA Infotech is the ideal choice for anyone looking to take their career to the next level in the cloud computing industry.