[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/20030415/83f03eed/attachment-0001.html>