"Forced Replication"

Although some of the users must synchronize from a distance, I would like to
develop a macro that would automatically synchronize the replicas located
within the same building/server. I have some senior executives that wish to
view the data but I am not sure the 'lessons' on how to synch each time they
view the data will go over well. It would be nice to have a macro, possibliy
using a scheduler program, that would synch each of the replicas during off
hours. Are you aware of a macro, program or other method that I might
accomplish this? I know that I can individually synch, but I would like to
automate the process.

Take a look at the MS Replication FAQ:
http://support.microsoft.com/kb/q282977/

Among other things, it talks about how you can automate replication. A
number of trade press books also cover this.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L


"00don" wrote in message
...
Although some of the users must synchronize from a distance, I would like
to
develop a macro that would automatically synchronize the replicas located
within the same building/server. I have some senior executives that wish
to
view the data but I am not sure the 'lessons' on how to synch each time
they
view the data will go over well. It would be nice to have a macro,
possibliy
using a scheduler program, that would synch each of the replicas during
off
hours. Are you aware of a macro, program or other method that I might
accomplish this? I know that I can individually synch, but I would like
to
automate the process.

Thank you for the direction. I cannot find the automate replication issue on
the listing... is this the same as "indirect synchronization?" Sorry, I
would still consider myself a newbe on this although I have developed a
number of databases. I will check my various Access books for this
particular issue but if you know of a "best" book, that would help.

Again, thanks for the help!

"Roger Carlson" wrote:

Take a look at the MS Replication FAQ:
http://support.microsoft.com/kb/q282977/

Among other things, it talks about how you can automate replication. A
number of trade press books also cover this.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L


"00don" wrote in message
...
Although some of the users must synchronize from a distance, I would like
to
develop a macro that would automatically synchronize the replicas located
within the same building/server. I have some senior executives that wish
to
view the data but I am not sure the 'lessons' on how to synch each time
they
view the data will go over well. It would be nice to have a macro,
possibliy
using a scheduler program, that would synch each of the replicas during
off
hours. Are you aware of a macro, program or other method that I might
accomplish this? I know that I can individually synch, but I would like
to
automate the process.

There isn't a step-by-step process in the FAQ. Synchronizing
programmatically is illustrated in section 8: "How can I synchronize in a
single direction?" It can be as simple as:
Call SynchronizeDBs("C:\MyRepl.mdb", "L:\OtherRepl.mdb")



Sub SynchronizeDBs(strDBName As String, strSyncTargetDB As String, _

intSync As Integer)



Dim dbs As DAO.Database



Set dbs = DBEngine(0).OpenDatabase(strDBName)



dbs.Synchronize strSyncTargetDB, dbRepImpExpChanges

End Sub



But that's deceiving, because if you have a conflict, you have to manage
that yourself. There is code provided in other sections to do this.



As for trade press books, Allison Balter's books usually have a section on
replication including how to use DAO to automate it. Check and see if you
can find a current version book by her.




--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L



"00don" wrote in message
...
Thank you for the direction. I cannot find the automate replication issue
on
the listing... is this the same as "indirect synchronization?" Sorry, I
would still consider myself a newbe on this although I have developed a
number of databases. I will check my various Access books for this
particular issue but if you know of a "best" book, that would help.

Again, thanks for the help!

"Roger Carlson" wrote:

Take a look at the MS Replication FAQ:
http://support.microsoft.com/kb/q282977/

Among other things, it talks about how you can automate replication. A
number of trade press books also cover this.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L


"00don" wrote in message
...
Although some of the users must synchronize from a distance, I would
like
to
develop a macro that would automatically synchronize the replicas
located
within the same building/server. I have some senior executives that
wish
to
view the data but I am not sure the 'lessons' on how to synch each
time
they
view the data will go over well. It would be nice to have a macro,
possibliy
using a scheduler program, that would synch each of the replicas
during
off
hours. Are you aware of a macro, program or other method that I might
accomplish this? I know that I can individually synch, but I would
like
to
automate the process.