I have a customer who has a database that needs to be available from two locations. I know there is the option of setting up a VPn between the sites but I would really like to use Azure to enable this.
I am fairly new to Azure and I am unsure exactly what is the best option.
I am also fairly unfamiliar with MS Access. Is has a customised front end interface and the database consists of an .mdb and a .mde file.
Azure SQL is one option. Would this work well over a 5meg broadband connection.
I also see the Remote App is something new from Azure which would allow true access from anywhere. Is it possible to set a Access "Remote App" to default to a database stored in Azure SQL.