This is to ask whether accdb databases are suitable for this application, and how to connect the user with the database (and the phone network with the database if anyone has a comment on this).
I use an old pc program that downloads data from a local sensor, writes it to a small Access database (mdb), and gives the user queries to view graphs of the data and export it to Excel and other programs. I want to make a new system that does roughly the same but runs online. It doesn't need to be compatible with the old system.
So far I've written a new pc program (in C sharp) to download data from a local sensor and write it to an Access (accdb) file on the same pc. So the user gets a small Access file for each download, similar arrangement to before.
The new system is intended to download data remotely (mobile phone network) to a server in the cloud, and for the user to view graphs of the data, download data to their pc etc. There will only be a small number of users (probably one) connected at a time.
I tried mySQL when writing the first part of the new program but found Access easier. Would there be a database engine in my program in the user's pc, and if so is it best if it's the same as the database in the cloud? Is Access ok for this application?
The users are generally not software savvy, and their IT departments are sometimes not enthusiastic about new software, so the users' software needs to be as easy to install as possible, as well as easy to use. I don't know much about databases and program occasionally, at present in C sharp; so simple explanations would be welcome please.
Since there are no legacy restrictions it's an opportunity to start in the right direction, which is why I'm asking the question at an early stage. Thanks for any responses.