CODEWITHSUNDEEP
c#androidsql-serverxamarin.formsgoogle-cloud-platform
doc1429
doc1429

Reputation: 9

How to host an MS access database online?

For my college project I am making a social media app which stores user data on an MS access database. However its no good of a social media app if the data cant be accessed online, so how would I go about doing it? I've looked into google cloud but it seems pretty confusing. I am used to MS access so is there a way of me making an access database and simply uploading it to some server I can then access from my c# code?

Upvotes: 0

Views: 3041

Answers (1)

SteveC
SteveC

Reputation: 6015

There are 2 options I can think of that might work.

Option 1: Install Access in a cloud hosted VM and connect your application to it using ODBC (or other connection method). The upside is this would simple to do. The downsides are pretty major: 1) security is basically non-existent, and 2) Access is not scalable with higher concurrent requests (like a social media app might have). This could be done on AWS or Azure. Here's a Youtube video about how to do this.

Option 2: Use the 'Migration Assistant' to convert your Access project to Sql Server. Then use Azure SQL (either pay-as-go or DTU's) to host the database. Through the Azure portal you can get the connection string and ip address of the service and create firewall rules. There's probably more learning involved with this but SQL Server is a really good database. Here is a Youtube video about how to do this.

Upvotes: 1

Related Questions