> Michael Maes <michael.maes[ at ]community.nospam> wrote in
> news:F54F70A5-91C8-40A5-96DD-4E423C1EB33A[ at ]microsoft.com:
>
> > We develop dotNet applications.
> > We normally use SQL Server as datastore, but now we have a small
> > project on an existing Access Database.
> > Our issue is that there are two copies of the db, one on a lan and
> > one on a webserver (on the other side of the world).
> > Our customer want's to have those two (identical) database
> > synchronised bi-directional daily.
> > How can this be done in access (I know, a verry 'broad' question).
>
> Jet Replication White Papers:
> =============================
>
> * Jet 4:
http://support.microsoft.com/?id=190766 >
> PDF Versions:
>
http://dfenton.com/DFA/Replication/Files/WhitePaper4_0_Replication.pd> f (152KB)
>
http://dfenton.com/DFA/Replication/Files/WhitePaper4_0_InternetRepl> ication.pdf (678KB)
>
> * Jet 3.x:
http://support.microsoft.com/kb/164553 >
> PDF Version:
>
http://dfenton.com/DFA/Replication/Files/WhitePaper3_x_Replication.pd> f (238KB)
>
> It's probably helpful to read both if you are using Jet 3.x, as the
> Jet 4 version includes a lot of information based on the experience
> gained using Jet 3.x that was not available when the 3.x version
> article was written. However, keep in mind that any information
> about Jet 4 conflicts and replication errors will not apply to 3.x.
> If you're using Jet 3.x, it's probably a good idea to read Michael
> Kaplan's review of the differences between Jet 4 and Jet 3.x
> Replication at the link below
> (
http://www.mvps.org/access/general/gen0033.htm). >
> Jet Replication FAQs:
> =====================
>
> * Jet 4:
http://support.microsoft.com/?id=282977 >
> PDF version:
>
http://dfenton.com/DFA/Replication/Files/FAQ4_0_JetReplication.pdf> (320KB)
>
> * Jet 3.x:
http://support.microsoft.com/kb/182886 >
> PDF version:
>
http://dfenton.com/DFA/Replication/Files/FAQ3_x_JetReplication.pdf> (235KB) Note these two things:
>
> 1. It's probably helpful to read both if you are using Jet 3.x, as
> the Jet 4 version includes a lot of information based on the
> experience gained using Jet 3.x that was not available when the 3.x
> version article was written. However, keep in mind that any
> information about Jet 4 conflicts and replication errors will not
> apply to 3.x. If you're using Jet 3.x, it's probably a good idea to
> read Michael Kaplan's review of the differences between Jet 4 and
> Jet 3.x Replication at the link below
> (
http://www.mvps.org/access/general/gen0033.htm). >
> 2. If you're using Firefox, you may need to view these articles in
> IE, as in Firefox 1.5, the bottom of the article is hidden behind
> the footer of the page.
>
> Michael Kaplan on Jet 4 Replication vs. Jet 3.x:
> ================================================
>
>
http://www.mvps.org/access/general/gen0033.htm>
> Explains many of the improvements made to Jet 4.
> Michael Kaplan's old site, Trigeminal.com:
http://trigeminal.com/> This site has a number of articles and utilities that are essential
> to understanding and using Jet Replication.
>
> The newsgroup microsoft.public.access.replication:
> news://microsoft.public.access.replication
> ==================================================
>
> The premier location for discussion of replication issues. The
> Google Groups archives of this newsgroup are indispensable in
> solving replication problems as over the years, all the problems
> anyone can encounter have been brought up there and solutions
> provided form Michael Kaplan and other experienced users of Jet
> Replication.
>
> > The process has to be automated (we'll implement it in a Windows
> > Service).
>
> No, you won't. Jet is not thread-safe, so there are no tools
> available for implementing it as a service.
>
> --
> David W. Fenton
http://www.dfenton.com/ > usenet at dfenton dot com
http://www.dfenton.com/DFA/>