|That's one way fo doing it. Another much simpler way is to map the drive with database on to the computer with the application and use the mapped drive in exactly the same way as you would a local drive.|
VB6 has function to automatically map a drive when it is needed and delete the mapped drive when it is finished with it.
Which way you chose is dependant on whether you want multiple access to the database. The first method would be better for multiple access as it generates relatively little network traffic.
The second way, although simpler would create a lot of network traffic if more than one person is using the database at any one time. Assuming you are using MS Access which is a multi user database that is supposed to accommodate 10 concurrent users, it does tend to get very sluggish after three.