[AccessD] Table Linking via the internet

Unfortunately to get to a share over TCPIP (without the VPN) you need to
turn on NETBIOS over TCPIP and it can potentially be a security hole.

---
Eric Barro
Senior Systems Analyst
Advanced Field Services
(208) 772-7060
http://www.afsweb.com

  -----Original Message-----
  From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of John W. Colby
  Sent: Tuesday, April 15, 2003 10:07 AM
  To: accessd at databaseadvisors.com
  Subject: RE: [AccessD] Table Linking via the internet


  Cool stuff.  I have done the drive mapping to a remote folder using vpn
before, but never considered linking to a table in a db on the other end.  I
can see how it would be a bit slow, particularly over DSL.  If you use a
vpn, there is a TON of added overhead to the data transmitted back and forth
  John W. Colby
  Colby Consulting
  www.ColbyConsulting.com

    -----Original Message-----
    From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Reuben Cummings
    Sent: Tuesday, April 15, 2003 12:56 PM
    To: accessd at databaseadvisors.com
    Subject: RE: [AccessD] Table Linking via the internet


    I've done it.  I'm on DSL.  My ISP (and business partner) set up a
folder on the server.  He gave me the IP address and folder name, login and
password.

    I simply mapped a drive to it like I would any drive.  I could then link
to the BE.

    However, the performance was terrible to the point I am now
investigating replication over the DSL circuit between here and the ISP and
one other office, that is also on the same DSL service, to the ISP.

    Reuben Cummings
    Director of Software Development
    GFC, LLC
    phone: 812.523.1017
    email: reuben at gfconsultants.com

      -----Original Message-----
      From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of John Frederick
      Sent: Wednesday, April 16, 2003 9:30 AM
      To: accessd at databaseadvisors.com
      Subject: RE: [AccessD] Table Linking via the internet


      Good question.  I see the FTP options you're referring to in the
browse window in Linked Table Manager, but that looks like the general
purpose browse.  If you have a permanent circuit, you could use a package
named Web Drive (commercial for about $50).  It maps an FTP site into your
machine as a drive letter.  You have to set up the connection manually, as I
recall.  When you refer to it in Windows Explorer, it brings the directory
over into a local cache.  If you reference to the mdb, it apparently copies
the entire mdb into the local cache where you can reference it without
network delays.  If you change the cached mdb, you either have to manually
request that it be paged entirely back to the remote, or that happens when
you close Web Drive.

      I know only of a variety of kludgy partial solutions to this problem.
I'll be listening to this thread for some good ideas.
        -----Original Message-----
        From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of gregg steinbrenner
        Sent: Tuesday, April 15, 2003 7:21 AM
        To: accessd at databaseadvisors.com
        Subject: [AccessD] Table Linking via the internet


        Is there any way to link BE tables on a web server to a FE on a
local system?  I see options for FTP connections in the link table manager
but I have not been able to get them to work.


----------------------------------------------------------------------------
--

  Get your copy today at http://www.eMailBoss.com
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.471 / Virus Database: 269 - Release Date: 4/10/2003
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030415/8c8ae625/attachment-0001.html>