MS Access FE connecting to Azure SQL Server from anywhere (any IP)
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?
-
To connect to Azure SQL Database:
On the File menu, select Connect to SQL Azure (this option is enabled after the creation of a project). If you previously connected to Azure SQL Database, the command name will be Reconnect to SQL Azure.
In the connection dialog box, enter or select the server name of Azure SQL Database.
Enter, select, or Browse the Database name.
Enter or select Username.
Enter the Password.
SSMA recommends encrypted connection to Azure SQL Database.
Click Connect.
If there are no databases in the Azure SQL Database, you can create the first database using Create Azure Database option that appears on the click of Browse button.
Regards,
Please sign in to leave a comment.
Comments
1 comment