Hi Scott
I have started a new thread on this because I think is important.  (Please see the previous subject
heading "Invalid HTTP address" for the start of this conversation.

As I have stated before, there seems to be complications with Internet Synchronization since my
hosting provider has to install Microsoft Access and Microsoft Replication Manager on the server.
They also need to allow the uploading of Internet Synchronizer program in a separate folder and to
allow execution permissions on it.

Your suggestion is appreciated and indeed is one very good option.  I was thinking that for
automation of synchronisation in another way.  To achieve we would need to perform two operations:
1. update the Internet database.  2. update the client database.

1.Updating the client database.
To achieve this we would schedule the Internet database to write delimited fields with updates from
the last synchronisation (our own solution, ASP) to a text  file.   The next thing would be to write
a VB program to perform scheduled downloads of this textfile from the Internet and update the client
database with it.

2. Updating the client database.
To achieve this we would write a VB program and schedule it to write delimited fields with updates
from the last synchronisation to a text  file and then upload it to the Internet.  The next step
would be to write some ASP code on the website which would perform scheduled updates to the Internet
database.  Voila, synchronisation complete!

Or is there an easier way??


Kind Regards
Oliver Dempsey
00353 (0)502 26263
00353 (0)86 8219430

----- Original Message -----
From: "Scott Eisenreich" <seisenreich@h...>
To: "Access" <access@p...>
Sent: Tuesday, August 20, 2002 4:35 PM
Subject: [access] Re: Invalid HTTP address


> I have not tried using Syncronization before, but if the goal is to have
> access to a table over the ftp site, could you perhaps create a data access
> page that uses that table as it's data source & create a link to it on the
> ftp site? It is pretty easy to do using the Access Page wizard & may provide
> a solution to your dilema. Access uses xml to communicate to the database &
> you can use javascript or vbscript to program other functions into your
> page. (vbscript is not compatible with some earlier versions of NetScape, so
> I usually try to stick with javascript).
>
>
> >From: <odempsey@b...>
> >Reply-To: "Access" <access@p...>
> >To: "Access" <access@p...>
> >Subject: [access] Re: Invalid HTTP address
> >Date: Mon, 19 Aug 2002 19:28:36 +0100
> >
> >Hi Scott
> >thanks for that information, it appears from the documentation that I need
> >to install Microsoft
> >Replication Manager on the server and on the client computer. Replication
> >Manager is included as
> >part of the Microsoft Office 2000 Developer product.
> >
> >I haven't got a copy of Microsoft Office 2000 Developer and I'm not sure if
> >I can upgrade my Access
> >2000 since this product is nolonger available.
> >
> >the other issue that I will have to look into is whether our hosting
> >provider will allow the
> >installation of of Internet Synchronizer program (mstrai40.exe) that
> >handles the exchange of
> >information with Internet or intranet replicas that are requesting
> >synchronization.  I will also
> >have to see will they grant execute permissions for it.
> >
> >Another issue which seems to be a disadvantage is this: - "Although it is
> >possible to manage a
> >partial replica as the hub replica on your server, it is not a good idea.
> >The Microsoft Jet
> >Synchronizer will only use a partial replica for synchronization if it is
> >the only member of the
> >replica set that is managed. Also, it is important to remember that you can
> >never synchronize a
> >partial replica to another partial replica. So if you are distributing
> >partial replicas, you must
> >manage a full replica."   This seems to mean that if the main database was
> >on a local Intranet
> >server and you wanted to be able to have a partial replica on the Internet
> >server and distribute
> >more partial replicas to over the local intranet, it couldn't be done.  It
> >seems that it can be done
> >if there are not other partial replicas.
> >
> >Has anybody any experience with replication over the internet?  Am I on the
> >right track here?
> >
> >Your comments would be welcome
> >
> >
> >Kind Regards
> >Oliver Dempsey
> >00353 (0)502 26263
> >00353 (0)86 8219430
> >
> >----- Original Message -----
> >From: "Scott Eisenreich" <seisenreich@h...>
> >To: "Access" <access@p...>
> >Sent: Monday, August 19, 2002 3:34 PM
> >Subject: [access] Re: Invalid HTTP address
> >
> >
> > > I think I see the problem. Direct syncronization is used normaly for a
> >path
> > > (UNC or mapped drive) you should be able to use Internet Syncronization.
> > > Look at
> > >
> >http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/intrjet4.asp
> > >
> > >
> > > >From: <odempsey@b...>
> > > >Reply-To: "Access" <access@p...>
> > > >To: "Access" <access@p...>
> > > >Subject: [access] Re: Invalid HTTP address
> > > >Date: Mon, 19 Aug 2002 12:37:03 +0100
> > > >
> > > >Hi Scott
> > > >I can ftp to the site using an  ftp program but I can't seem to be able
> >to
> > > >do it using synchronise
> > > >in Access.  Here is a couple of screen shots of what I am doing: -
> > > >
> > > >http://www.barrowvale.ie/sync/sync1.gif
> > > >http://www.barrowvale.ie/sync/sync2.gif
> > > >
> > > >Does anybody know what the problem is?
> > > >
> > > >
> > > >Kind Regards
> > > >Oliver Dempsey
> > > >00353 (0)502 26263
> > > >00353 (0)86 8219430
> > > >
> > > >----- Original Message -----
> > > >From: "Scott Eisenreich" <seisenreich@h...>
> > > >To: "Access" <access@p...>
> > > >Sent: Monday, August 19, 2002 12:02 PM
> > > >Subject: [access] Re: Invalid HTTP address
> > > >
> > > >
> > > > > Hi Oliver,
> > > > >
> > > > > It looks like the url is working now. I just connected (got a login
> > > >prompt).
> > > > >
> > > > >
> > > > > >From: <odempsey@b...>
> > > > > >Reply-To: "Access" <access@p...>
> > > > > >To: "Access" <access@p...>
> > > > > >Subject: [access] Re: Invalid HTTP address
> > > > > >Date: Mon, 19 Aug 2002 11:29:23 +0100
> > > > > >
> > > > > >Hi Steve,
> > > > > >I've tried every possible combination that I can think of,
> >including
> > > >the
> > > > > >http address and even the
> > > > > >IP address but it always gives me the same error
> > > > > >
> > > > > >
> > > > > >Kind Regards
> > > > > >Oliver Dempsey
> > > > > >00353 (0)502 26263
> > > > > >00353 (0)86 8219430
> > > > > >
> > > > > >----- Original Message -----
> > > > > >From: "Steven White" <Steve.White@m...>
> > > > > >To: "Access" <access@p...>
> > > > > >Sent: Monday, August 19, 2002 1:30 AM
> > > > > >Subject: [access] Re: Invalid HTTP address
> > > > > >
> > > > > >
> > > > > > > Well, I couldn't say fo sure, but I think if you look at the
> >error
> > > > > >message, and compare it to the
> > > > > > > address yr getting, you might find the answer.
> > > > > > >
> > > > > > > And if you can't be bothered figuring that out:
> > > > > > >
> > > > > > > You're getting an invalid HTTP address, when you're looking up
> >an
> > > >FTP
> > > > > >address
> > > > > > >
> > > > > > > Two totally separate protocols.
> > > > > > >
> > > > > > > I've never worked with internet synchs, but I'm guessing that's
> >the
> > > > > >problem
> > > > > > >
> > > > > > > Steven
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > _________________________________________________________________
> > > > > Send and receive Hotmail on your mobile device:
> >http://mobile.msn.com
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> > >
> > > _________________________________________________________________
> > > Send and receive Hotmail on your mobile device: http://mobile.msn.com
> > >
> > >
> > >
> >
> >
> >
>
>
>
>
> _________________________________________________________________
> MSN Photos is the easiest way to share and print your photos:
> http://photos.msn.com/support/worldwide.aspx
>
>
>