Is it posible to connect MS-Access database with Azure?

Question

Hi,
I am very new learner to Azure.
I am using C# VS2015 Windows Applications. I wish to Keep my MS-Access 2013 Database with azure and need to do remote connection and retrieve my data's.. It it possible?

Usually I use to do remote database connection by Static IP. So that the connection strings will be like the following

String RmConStr= "Provider=Microsoft.ace.Oledb.12.0; Data Source='\\192.1.1.1\Shared_Folder\Data\MyDataBaseName.accdb'; Persist Security Info=False ";

Thanks

Answer 1

You can create an Azure VM on Azure, if more than one user will use the database try a D series VM (See the VM types here). After creating the VM, try to setup a VPN to connect to the VNET where Azure VM is deployed as explained here or you can try other ways to setup a VPN.

Put the MS access on a shared drive on the VM and once you are connected to the VNET of the Azure VM you should be able to access it.

Answer 2

When you link to the data, Access creates a two-way connection that synchronizes changes to the data in the SQL and Access database.

When you import data, Access creates a one-time copy of the data, so changes to the data in the SQL or Access database are not synchronized

Answer 3

Hi @Paranthaman From what I understand, if you are looking to host the MS-access DB in Cloud and connect through visual studio.
Another workaround will be to use the below.
You can use the Data Migration assistant to import MS-access database to Azure then access it from visual studio.
Migration guide: Access to Azure SQL Database

Please let us know if that help.

Regards,
Oury