MS Access VS MSQL Server

[nector]

We dumped MS SQL Server for MYSQL as relational database due to speed we have been using this MYSQL databases with MS Access as front end and has proved to be reliable and our users like the speed compared to MS SQL Server which makes the speed horrible even if you do what is so called tunning the gain is not much.

Now we need to move further by providing the same solution through the mobile phone. Since MS Access cannot handle this, is there any platform that provide coding, nice forms and reports that can be interesting?

(1) Java NetBeans is ok, but the forms and reports are quite challenging especially JFrame forms

When you are using MYSQL our users fail to find any difference between storing the data on a local computer and cloud-based computer, that is the main reason why MS Access is popular, and we will keep it that way

 

[Pat Hartman]

Your title has nothing to do with your question. You might want to change it.

 

[dalski]

I wondered why people only seem to talk about MS SQL Server/ Azure. Azure seems to be ridiculously expensive & always wondered why don't people use PHP/ MySQL...

 

[CJ_London]

providing the same solution through the mobile phone. Since MS Access cannot handle this

Providing your phones support terminal server- it can be done at a cost - and clearly form design needs to take the screen size into account and how users navigate the app

 

[GPGeorge]

Having done some work with PowerApps for smart phone and tablet environments, I can tell you the main reason we don't write our apps to work on smart phones is that--except for some really simplistic applications-- their form factor and screen size militate forcefully against that approach. Your phone is fine for doom-scrolling Facebook or watching YouTube videos. It's not so good for data entry involving more than making a selection from a dropdown.