[AccessD] Table Linking via the internet

I can assure you it was painful.  This is an accounting package that we are
wanting to share and rewriting recordsets would be a real chore.

That's why I am exploring replicating the DB.

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 Jim Lawrence
(AccessD)
  Sent: Tuesday, April 15, 2003 11:00 PM
  To: accessd at databaseadvisors.com
  Subject: RE: [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/20030416/c34ea023/attachment-0001.html>