<!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=523184114-16042003><FONT face=Verdana size=2>Good point,
Eric. Thanks for covering my over sight.</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>Eric
Barro<BR><B>Sent:</B> Tuesday, April 15, 2003 1:46 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=311574418-15042003><FONT face="Lucida Sans Unicode"
color=#0000ff size=2>Unfortunately to get to a share over TCPIP (without the
VPN) you need to turn on NETBIOS over TCPIP and it can potentially be a
security hole.</FONT></SPAN></DIV>
<DIV> </DIV>
<P><FONT size=2>---<BR>Eric Barro<BR>Senior Systems Analyst<BR>Advanced Field
Services<BR>(208) 772-7060<BR><A href="http://www.afsweb.com/"
target=_blank>http://www.afsweb.com</A> </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>John W.
Colby<BR><B>Sent:</B> Tuesday, April 15, 2003 10:07 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=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></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>