[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.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030415/571365f7/attachment-0001.html>