Online MS Access Databases on Azure - Enhanced security using Azure Active Directory accounts.

Related Videos:
Access on Azure SQL - How to create an online Access application using Azure SQL and ODBC
Online MS Access Databases on Azure - Enhanced security using Azure Active Directory accounts.
You are watching this video now!
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:

#msaccess #azuresql

[seanmackenziedataengineering]

*If you are experiencing multiple logins*, you can fix that by refreshing your table links when your app opens. It will prompt the user one time for their AD login and that's it:

Sub LinkTables()
Dim strCnn
DoCmd.SetWarnings False
DoCmd.DeleteObject acTable, "PERSON"
DoCmd.DeleteObject acTable, "PROJECT"
DoCmd.DeleteObject acTable, "PROJECT_TIME"
DoCmd.DeleteObject acTable, "MyCurrentUser"
DoCmd.SetWarnings True
DoCmd.TransferDatabase acLink, "ODBC", strCnn, acTable, "PERSON", "PERSON"
DoCmd.TransferDatabase acLink, "ODBC", strCnn, acTable, "PROJECT", "PROJECT"
DoCmd.TransferDatabase acLink, "ODBC", strCnn, acTable, "PROJECT_TIME", "PROJECT_TIME"
DoCmd.TransferDatabase acLink, "ODBC", strCnn, acTable, "MyCurrentUser", "MyCurrentUser"
End Sub

[bryanstark]

very cool! Where is the documentation on this functionality? I am making a VSTO addin and wondering how to incorporate Azure AD as the login function. Do you have sourcecode for this project that maybe I can modify for a VSTO addin?

[HeyTezza]

These videos are really helpful, really appreciate them :)

[gioargentati]

Thank you very much for posting this informative video, Sean! I have a problem...whenever my users open my access database (with linked Azure SQL tables), it demands that the user authenticate over and over for every single Azure SQL table... How can I make it so that users only have to authenticate once?

[akokohjoel]

Pls show us how to link ms access to dataverse in power app

[akokohjoel]

I will appreciate it pls post simple approach to Link ms access to azure. With less stress and code. Pls