I run a fantasy basketball league. I'm creating a program in VB6, using an Access database, that allows owners of teams to login and change details of their team. What I want to be able to do is allow them to then upload these changes to a central server - i.e. a PC that I have running 24/7 specifically for this purpose. I would also like them to be able to request an update file -- not necessarily an updated .exe, but an updated database (either an .mdb or a custom format that I will create) for instance, which is then inputted into their program. Along the same lines, it would be useful if they could interact with other members of the league through this system: i.e. uploading a trade offer, and then the server notifying the other member that they have a trade offer and allowing them to download it.

I attempted to do using FTP but it became unwieldy, and sometimes the changes wouldn't upload. I'm not quite sure what I need to do to make the client/server connection. Ideally I would like something where on my end, it tells me who is logged in and who has uploaded changes. On their end, they simply need the ability to upload changes, and to download any updates.

Basically:

Client: Sends updated lineups (etc.) to Server / Sends messages to Server for retrieval by other clients

Server: Sends updated database to Client / Sends notification of awaited messages to Client

Hopefully that's clear. All I need is samples of code/functions that I can use to achieve this, or some simple app that I can modify for my own purposes. Any pointers or code snippets you could offer would be appreciated.

Thanks in advance!