I've enjoyed 'lurking' in the forum, but now have a problem where I could use some help. I have an application (accounting, ordering, etc.) I developed in VB6 for a client where some dozen computers access an shared Jet database on a server over a LAN (all machines running WinXP). To date, all inventory & accounting was under the same roof, so there was no problem getting to the database over the LAN. Now, a new warehouse is being used a mile or so away, and half the inventory is being managed there. We'd like to have a couple of computers at that remote location that network to the database on the server at the main location. My application expects to see the directory of the database as a drive letter\directory--is there any way that a shared directory on the server can be seen by a remote computer over the internet as a drive letter; and then the remote computer connect to it as if it were on a LAN?

I know nothing about VPN, but, from what I've read, it sounds like it could be the only solution. Is there a simpler solution I'm overlooking that VB6 could supply? I appreciate your help!