I am looking for the best method of sharing database info between an vb.net desktop app and a server?
I am wanting to start a membership website where people can signup from my PHP/Mysql server and clients download an VB.net App.
When the VB.net app is loaded it asks for a username and password that was signup up earlier.
I have about 150 records that the user can modify on the membership.
Here is what I thought about doing. but I am not sure if there is a better way.
After the user successfully logs in to the software, download all records in maybe a CSV file then take that file and create a on the fly database using SQLite so all records can be used by the software. For every record that was modified create another CSV file and reupload to server where the server would change the MYSQL database for that client.
Here are my limits that I don't want.
1. The software must not ever connect directly with the mysql server, no passwords of any kind must be in the software.
Problems that I can see.
1. If the user does not click a button to reupload the CSV file then no changes would be made to the server.
What would be the best way to handle this?