Access on Azure SQL - How to create an online Access application using Azure SQL and ODBC

In this episode, we're going to explore how to design your database in order to go online instead of with an Access backend for data storage. I'll show you how to create your Azure SQL database, create the tables you will use, and then link to those tables using Access linked tables. From there, I'll show you how to build a form for data entry, and then some VBA code with slight changes in recordset handling that you'll need when you're working with Azure as a backend. Many thanks for this excellent viewer requested topic!

Related Videos:
Access on Azure SQL - How to create an online Access application using Azure SQL and ODBC
You are watching this video now!
Online MS Access Databases on Azure - Enhanced security using Azure Active Directory accounts.
Microsoft Access on Azure SQL: ODBC Overview with DAO
How to Migrate Slow Queries to Azure for Speed in Your Azure-Enabled Microsoft Access Application

Interested in transforming your career or finding your next gig?

Want my team to do a project for you? Let's get to it!

Want to get access to premium content made just for you and have a chat with me? Find me on Patreon :

Demo of my BZ RDP Cloaker:

Want to work with me 1:1? Contact me today and book your free 20 min consultation!

Follow me on social media:

Get Microsoft Office including Access:

Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try:

#access #azuresql #dataengineering

[niavras]

Hi Sean, perfect video as always! Please stay more on this subject of Access - Azure connectivity, as sooner or later we will all gonna have to go this way.

[miles]

Hi Sean - once again revisiting this video. I do not know how long it would’ve taken me to achieve the connection if it were not for your channel. Thank you so much for all you do

[SaniExp]

Thank u very much i have been trying to connect my database to azure for years and its the first time it works for me❤️❤️❤️

[櫻井雅英]

It was very easy to understand from beginning to end, and I appreciate the wonderful material! thank you very much!

[philferrero]

This was a big help - thanks! I was having a rough time trying to figure out how to connect to Azure SQL through MS Access on an Azure VM on the tenant. Things connected fine from Access on other PCs, even worked using SSMS on the Azure VM. I just could not get a connection through Access on the VM. After viewing this video, I found that it needed to have the server piece of the connection string, the "tcp:" prefix, included. Only for Access running on the Azure VM; no other methods of connection required that "tcp:" prefix.

[NjonjoNdehi]

Many thanks from Kenya. Wonna use this for a school that has over 3, 500 kids in 5 campuses. 👍🏽

[jamesmartinez]

Señor Sean, Excelente explicación, muchas gracias por su generosidad al compartir sus conocimientos.

[shafiqueahmad]

did you know your 1 lesson solved my 10 problems. i always waiting for you.

[miles]

Hi Sean, this specific video and your MS playlist in general has been incredibly helpful. My question is: Troubleshooting best practices for not being able to see your databse object in MSS? I have tried to create a new database and refreshed/logged out - I still am not seeing the equivalent of your “Project Timelines” database - although I do see it as live on the Azure portal.

Thank you,
Miles

[PeterW]

Thank you for the video. I needed to use ODBC;DRIVER={ODBC Driver 17 for SQL Server} otherwise I was getting the "Could not find installable ISAM" error.

[kewl]

Excellent video and instructions. Thanks so much for putting this together!

[HeyTezza]

This is really helpful, I’m about to migrate our back end data from SharePoint to an azure back end, we have some tables that have attachments, do you know if these are able to be added as a field, they can be a pdf, doc or picture etc?

[brahimaoumeur]

First of all .. Tanks For This Video !!
The Way you Did it just works with small and simple programs not for heavy or complicated databases with a lot of queries and functions and VBA's
Is There Any Solutions For This Types Of Databases Plz .... !?

[shafiqueahmad]

i am very excited to see your another valuable lesson addition.

[ЗиновьяЗотова]

Hi Sean. Thank you for video! Very clear! Question: Once you entered password 3 times for ODBC connection, when you give database file to the user and user will install it on another machine, will user have to put password 3 times again, or connection is already saved inside access file and it will work right away?

[darrynvanrooyen]

Great video...out of interest sake can the same access connection be achieved to a Azure server without SQL but with SQL Express instead?

[ballaomer]

Hi, thanks for your great video
You mean just back end convert it to SQL Azure and the interface is access file ?
my question is : I would like to share access database over internet like google and used by multi user over internet
what is the best solution to do that?
Regars

[ahmoselsagganfm]

Hi Sean - it's really an achievement, many thanks. But still need your help figure out the reason on "why receiving Run-time error '3146': ODBC-call failed, because the Data source name not found and no default driver specified (#0)" - appreciate your response, I do need your help on getting this issue resolved - Thanks

[YvesAustin]

Great video as always Sean. Could you pls elaborate on how Azure manages/resolves conflicts when entering data concurrently? Is it like the "red x" in OneDrive where the user picks one version or the other? What happens if I have a multi-user environment where two users are attempting to enter a new order at the same time (with OrderID being my primary key)?

[sgk]

Hi Sean
Thanks for the very informative video. Just wanted to know whether we can connect using Azure Key Vault Secret instead of giving the server and login details in Acccess?