<!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=635114614-16042003><FONT face=Verdana size=2>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.</FONT></SPAN></DIV>
<DIV><SPAN class=635114614-16042003><FONT face=Verdana
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=635114614-16042003><FONT face=Verdana size=2>That's why I am
exploring replicating the DB.</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>Jim Lawrence
(AccessD)<BR><B>Sent:</B> Tuesday, April 15, 2003 11:00 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=410074203-16042003><FONT face=Arial color=#0000ff size=2>Hi
Ruben:</FONT></SPAN></DIV>
<DIV><SPAN class=410074203-16042003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=410074203-16042003><FONT face=Arial color=#0000ff size=2>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.</FONT></SPAN></DIV>
<DIV><SPAN class=410074203-16042003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=410074203-16042003><FONT face=Arial color=#0000ff size=2>My
two cents worth.</FONT></SPAN></DIV>
<DIV><SPAN class=410074203-16042003><FONT face=Arial color=#0000ff
size=2>Jim</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>Reuben
Cummings<BR><B>Sent:</B> Tuesday, April 15, 2003 9:56 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=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></BLOCKQUOTE></BODY></HTML>