I'm currently building an online inventory system using mysql and vb6. I'm quite confuse on what method to use to finish this. The application will have a server that records on items and then gives it to its branches for sales. I would like it to record all the items being sold and update the server which is a city away.
These are my options:
1. Have the client system generate a text file or excel file to be emailed to the server location to update its records(which would give an extra work to the one who uses the server)
2. Use the public ip of the server as means of connection for updating(which i consider is not a secured option)
3. Use VPN(which would not be cost friendly for the client)
4. Have an online database/domain that will hold the transactions from the clients for daily updates on the server
would it be done using vb6 and mysql? Anyone who could give me a better idea on what to use and how to achieve this?