<!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.2800.1141" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=773030417-15042003><FONT face=Arial color=#0000ff size=2>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</FONT></SPAN></DIV>
<P><FONT size=2>John W. Colby<BR>Colby
Consulting<BR>www.ColbyConsulting.com</FONT> </P>
<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>Reuben
Cummings<BR><B>Sent:</B> Tuesday, April 15, 2003 12:56 PM<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=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></BLOCKQUOTE>
<DIV>
<HR>
</DIV>
<DIV>Get your copy today at <A
href="http://www.eMailBoss.com">http://www.eMailBoss.com</A></DIV></BODY></HTML>