I am currently developing software whereby VB accesses an (access) database on a local machine. Fine, no problem.
However we (now) plan to be able to run the software across a network, allowing several client machines (40 max) to access a database on a server.
(trafic is likely to be minimal with no more than 2-3 machines at once trying it accessing it).
Possible solutions are:
1. Having a shared drive on the server, whereby any client machine can access it as if it were on a local drive.
2. Writing client and server ends, using a specific port for data transfer.
I've no idea how to implement the 2nd option. If anyone has done this kind of thing before then I'd love to hear from you!