I have started a thread previously on updating a VPS server, but now I wish to explore updating a local server database through the internet.
This is the previous thread:

I have a VB6 program and a database on our local file server.
I now wish to change the program so that users on our construction sites can update the database via the internet by way of scripts.
I presume that I need a scripting file on the server which can update the database and that the VB6 program should be changed to send scripts to the database.

Can you please steer me into this unfamiliar ground.