FallenAngel-9408 avatar image
0 Votes"
FallenAngel-9408 asked XingyuZhao-MSFT commented access to online database, what is the best solution

I want to create an app to connect to online database so it can read the data (read only). The database size is not to big, right now is around 2MB. I am trying to find what will be a better solution for my project. I want something that is not expensive and easier to connect to app or even MS access. So basically what I am asking is what you think is ideal to that? Where can I host my Sql or MySql database? Data will not imported from the app, but from an excel file. And one more question, I will be able to filter data from my app? Also I want other users to connect to the database with the same app and I don't want to add custom IP's for them to be able to access it.

· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @FallenAngel-9408 ,
Hope the following references could be helpful to the question.

  1. Ways to share an Access desktop database

  2. What is Azure SQL?

1 Vote 1 ·

Thank you for your reply. I took a look in the info you send it me. It was helpful to understand some things. Pricing is not so clear for me. But I will figure this out. Thank you for your help.

0 Votes 0 ·

Hi @FallenAngel-9408 ,
How's the question going? Did you solve the problem?

0 Votes 0 ·

0 Answers