Unanswered

Azure connection created by Access Web Apps

(0) Share

Report

Posted on by Drrickryp Super User 2024 Season 1

I have built Powerapps using the Azure connection created by Access Web apps. This has allowed me to maintain all of my data going back 15 years. I just had an awful thought though. Is the Azure connecion that is the back end for MS Access going to be deleted in April?

Categories:

Connecting to Data

General Questions

I have the same question (0)

All responses (3)

Answers (0)

Meneghino 6,949 on at

Like (0)

Report

Re: Azure connection created by Access Web Apps

Hi @Drrickryp I strongly suggest migrating all your data to Azure SQL Database.
I was also a heavy user of Access Web Apps, but Azure is great and have not looked back.
Here are some references:
https://baizini-it.com/blog/index.php/2017/09/26/powerapps-and-azure-sql-database-101/
https://baizini-it.com/blog/index.php/2017/09/27/powerapps-simple-azure-sql-database/

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

Re: Azure connection created by Access Web Apps

Thanks for the advice but isn't the data already in SQL Azure since it is the back end for Web Apps? I have been using the data stored in the Web App by using the SQL server connection information as described in https://powerusers.microsoft.com/t5/General-Discussion/PowerApp-Connect-to-access-web-app-data/td-p/1668.

Was this reply helpful? Yes No
Meneghino 6,949 on at

Like (0)

Report

Re: Azure connection created by Access Web Apps

@Drrickryp, I am not an expert and not from Microsoft, but my understanding is that yes the back end for AWA is Azure, but that AWA will at some point (April) be discontinued, which also means that the Azure back end will be switched off.
Rather than risk this, I have migrated all my data to a new instance of Azure which is under my control.
Hence the links above as to how to do this.

Was this reply helpful? Yes No