I have created an MS Access application that uses Azure SQL Server as the backed Db. The Access app is designed as much as possible to act like a web app in that nothing is stored locally that couldn't alternatively be saved in a cookie for while the users is working on a specific record. I have set the main offices IP in the Azure Db firewall and it works great when in the office.
However the desire is to allow the users to use the tool from anywhere, i.e. their home, a hotel, a coffee shop, etc. I have determined that this cannot be done directly between the local Access app and the Azure SQL Db (on the basis that I can't keep adding new origination IPs on a case by case basis).
Is it possible to create a Azure App Service or App Certification that MS Access can use to authenticate to the Azure close subscription and then through that, have access to the Azure Db?
Please sign in to leave a comment.