[AccessD] Table Linking via the internet

Good point, Eric.  Thanks for covering my over sight.

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 Eric Barro
  Sent: Tuesday, April 15, 2003 1:46 PM
  To: accessd at databaseadvisors.com
  Subject: RE: [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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030416/7461dec8/attachment-0001.html>