Visual Basic 6.0 Remote database How?

问题:

I need VB6 code to connect a *.mdb file to one PC to another over the internet. When I update/save my database it must update via internet to other-side PC.

I wrote a VB6 simple database program that can save Roll_Num, Name, Address of student. It works on my PC, but how do I update/save/copy my *.mdb file to the other-side of the HOME PC by connecting it. How do I use my home PC to update it?

回答1:

Dear sir: Your easiest way to remotely connect to a *.mdb file is to learn about Virtual Private Networks (VPN).

To make a VPN Server on a Windows XP computer: http://www.onecomputerguy.com/networking/xp_vpn_server.htm

You will need to become familiar with how network routers and firewalls work. You will need to learn about port forwarding and virtual server settings (example: http://web.belkin.com/support/kb/kb.asp?a=1448). It would be best if you could find someone who knows these things who lives nearby you for help.

Once your VPN server is up and working on the computer that has the *.mdb file, you will need to setup a VPN client on the "home PC": http://www.onecomputerguy.com/networking/xp_vpn.htm

You will need to make the folder that contains the *.mdb file into a share. Look for "Sharing Drives or Folders" at: http://www.onecomputerguy.com/networking/xp_network.htm

Once your VPN server and VPN client are setup, the "home PC" (client) can connect to the *.mdb file on the "other-side PC" (server). The file path will be of the form \\server\share\file.mdb.

Good luck!