[AccessD] Table Linking via the internet

Hi Ruben:

I think linking and binding Access tables across the web is always going to
be painfully slow and unless you have a fiber connection, unrealistic. I
tried that scenario, in a number of different ways, over five years ago and
it was a total disaster. Without trying to ignite the bound/unbound
controversy again, creating an ADO-OLE recordset framework solve the problem
and, for me, made remote databases, possible.

My two cents worth.
Jim
  -----Original Message-----
  From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Reuben Cummings
  Sent: Tuesday, April 15, 2003 9:56 AM
  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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030415/a228819c/attachment-0001.html>