<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2600.0" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=864455116-15042003><FONT face=Verdana size=2>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.</FONT></SPAN></DIV>
<DIV><SPAN class=864455116-15042003><FONT face=Verdana
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=864455116-15042003><FONT face=Verdana size=2>I simply mapped a
drive to it like I would any drive. I could then link to the
BE.</FONT></SPAN></DIV>
<DIV><SPAN class=864455116-15042003><FONT face=Verdana
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=864455116-15042003><FONT face=Verdana size=2>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.</FONT></SPAN></DIV>
<DIV> </DIV>
<P><FONT size=2>Reuben Cummings<BR>Director of Software Development<BR>GFC,
LLC<BR>phone: 812.523.1017<BR>email: reuben@gfconsultants.com</FONT> </P>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com]<B>On Behalf Of </B>John
Frederick<BR><B>Sent:</B> Wednesday, April 16, 2003 9:30 AM<BR><B>To:</B>
accessd@databaseadvisors.com<BR><B>Subject:</B> RE: [AccessD] Table Linking
via the internet<BR><BR></FONT></DIV>
<DIV><SPAN class=296331714-16042003><FONT face=Arial color=#0000ff size=2>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. </FONT></SPAN></DIV>
<DIV><SPAN class=296331714-16042003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=296331714-16042003><FONT face=Arial color=#0000ff size=2>I
know only of a variety of kludgy partial solutions to this problem. I'll
be listening to this thread for some good ideas.</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com]<B>On Behalf Of </B>gregg
steinbrenner<BR><B>Sent:</B> Tuesday, April 15, 2003 7:21 AM<BR><B>To:</B>
accessd@databaseadvisors.com<BR><B>Subject:</B> [AccessD] Table Linking via
the internet<BR><BR></FONT></DIV>
<DIV><SPAN class=680411311-15042003><FONT face=Arial color=#0000ff size=2>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.</FONT></SPAN></DIV>
<BLOCKQUOTE> </BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>