<!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=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></BODY></HTML>