<html>
<body>
I have been involved with A97 replication for a number of years.
While definitely not an expert, I have tried a number of methods.
In all cases I distributed a runtime version of Access. I found
that internet synchronization was a disaster because of lack of security
on the server (it needed anonymous user access which meant that anyone
could get in - and did!).<br><br>
Now I use dial up connections and indirect synchronization. I
distribute replication manager as part of the installation and once it is
configured on the users machines they are (mostly) able to follow the
simple synchronization process using it.<br><br>
I am not sure about XP but would be pretty certain that it would be
distributable as well.<br><br>
David Emerson<br>
Dalyn Software Ltd<br>
New Zealand<br><br>
At 20/03/2003, you wrote:<br>
<blockquote type=cite class=cite cite><font face="Comic Sans MS" size=2 color="#0000FF">No,
I haven't. When I've used replication, I didn't try to do it on a
schedule because I had no control over the users' schedules.
Procedurally, our users were instructed to sync their replica at the
beginning of each session to get the latest updates and at the end of a
session to upload their own changes. You could set up code to sync
the database when they opened it, but there is at least a slight delay
involved with that.</font><br>
<br>
<font face="Comic Sans MS" size=2 color="#0000FF">Charlotte
Foust</font><br>
<dl>
<dd><font face="tahoma" size=2>-----Original Message-----<br>
<dd>From:</b> Doug Murphy
[<a href="mailto:doug@murphyscreativity.com" eudora="autourl">mailto:doug@murphyscreativity.com</a>]
<br>
<dd>Sent:</b> Thursday, March 20, 2003 1:36 PM<br>
<dd>To:</b> accessd@databaseadvisors.com<br>
<dd>Subject:</b> RE: [AccessD] Access XP Developer and replication
manager<br><br>
</font>
<dd><font face="arial" size=2 color="#000080">Charlotte,<br>
</font><br>
<dd> <br><br>
<dd><font face="arial" size=2 color="#000080">Thank you. I guess my
ignorance is going to show here but that is how I learn, sometimes.
My objective, I think, is to have the replication manager on the users
system so I can set up the replicas on the various computers and set up
the synchronization schedule. From what I understand if I use the
Access menu I can make the replicas and put them on the various computers
but I can not get automatic synchronization, or indirect
synchronization. It seems like a real waste to put the full
developer edition on a computer just to get the replication manager tool,
but this is a MS product.<br>
</font><br>
<dd> <br><br>
<dd><font face="arial" size=2 color="#000080">From the ADH it looks like
I could do everything through use of the Jet Replication Object and some
code, but I was looking for a user friendly way of doing this. Have
you had any experience with managing synchronization this way?<br>
</font><br>
<dd> <br><br>
<dd><font face="arial" size=2 color="#000080">Doug<br>
</font><br>
<dd> <br><br>
<dd> <br><br>
<dd> <br><br>
<dd><font face="tahoma" size=2>-----Original Message-----<br>
<dd>From:</b> accessd-admin@databaseadvisors.com
[<a href="mailto:accessd-admin@databaseadvisors.com" eudora="autourl">mailto:accessd-admin@databaseadvisors.com</a>]
On Behalf Of </b>Charlotte Foust<br>
<dd>Sent:</b> Thursday, March 20, 2003 12:57 PM<br>
<dd>To:</b> accessd@databaseadvisors.com<br>
<dd>Subject:</b> RE: [AccessD] Access XP Developer and replication
manager<br>
</font><br>
<dd> <br><br>
<dd><font face="Comic Sans MS" size=2 color="#0000FF">Replication manager
is an administrative tool, not an end user tool. The users of your
app will be able to synchronize without any kind of replication manager
because replicas have the capability of synchronizing built in.<br>
</font><br>
<dd> <br><br>
<dd><font face="Comic Sans MS" size=2 color="#0000FF">Charlotte
Foust<br>
</font><br>
<dd><font face="tahoma" size=2>-----Original Message-----<br>
<dd>From:</b> Doug Murphy
[<a href="mailto:doug@murphyscreativity.com" eudora="autourl">mailto:doug@murphyscreativity.com</a>]
<br>
<dd>Sent:</b> Thursday, March 20, 2003 12:54 PM<br>
<dd>To:</b> accessd@databaseadvisors.com<br>
<dd>Subject:</b> [AccessD] Access XP Developer and replication
manager<br>
</font><br>
<dd><font face="Courier New, Courier" size=2>Hi List,<br>
</font><br>
<dd><font face="Courier New, Courier" size=2>I have what seem like a
simple question but I don't seem to be able to find the answer. I
have Office XP Developer. I am looking at the use of replication to
keep several users</font>
<font face="Courier New, Courier" size=2>synchronized</font>
<font face="Courier New, Courier" size=2>on a really slow network plus be able to synchronize lap tops when they dial in. I got interested in this method after reading Arthur Fuller's article</font> <font face="Courier New, Courier" size=2>in</font> <font face="Courier New, Courier" size=2>"Inside Microsoft Access", March edition. </font> <font face="Courier New, Courier" size=2>I also read the chapter in the ADH on replication to get additional information. </font> <font face="Courier New, Courier" size=2>What I have been trying to determine is can I distribute the Replication Manager tool that comes with the Developer Edition with my database. It seems like this is the easiest way to set up the replication and synchronization schedule on the users</font> <font face="Courier New, Courier" size=2>system. I found an article on the web for access 97 that seems to indicate that Replication Manager is distributable but nothing on XP and have found</font> <font face="Courier New, Courier" size=2>nothing</font> <font face="Courier New, Courier" size=2>in any of my XP literature of help files.<br>
</font><br>
<dd><font face="Courier New, Courier" size=2>Has anyone had experience with this tool and been able to distribute it or does the user need to have the MOD on their machine?<br>
</font><br>
<dd><font face="Courier New, Courier" size=2>Thanks in advance for your assistance.<br>
</font><br>
<dd><font face="Courier New, Courier" size=2>Doug<br>
</font>
</dl></blockquote></body>
</html>