I've created a replicated database,now how can i allow 11 users
from 11
different countries to use this database ?
First, consider if you should use replication at all.
If you have a central location with a Windows server, then you can
likely avoid replication entirely and host the app on Windows
Terminal Server, with users running the app in a Remote Desktop
session on the Windows Terminal Server over a VPN across the
Internet. This is relatively easy to set up and puts all your
administration in one place. It is also relatively inexpensive.
Eleven users is well within the capabilities of a relatively
inexpensive Windows Server to support (as a rule of thumb I try to
alocate 128MBs of Terminal Server RAM for each simultaneous user, so
a server with 2GBs of RAM, which is quite inexpensive these days,
would be perfectly acceptable).
I've read a lot about replication,but i could not understand a
lot about it,can anybody help me?
Jet Replication White Papers
============================
* Jet 4:
http://support.microsoft.com/?id=190766
PDF Versions:
http://dfenton.com/DFA/Replication/Files/WhitePaper4_0_Replication.p
df (152KB)
http://dfenton.com/DFA/Replication/Files/WhitePaper4_0_InternetRepli
cation.pdf (678KB)
* Jet 3.x:
http://support.microsoft.com/kb/164553
PDF Version:
http://dfenton.com/DFA/Replication/Files/WhitePaper3_x_Replication.p
df (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.
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.
Things not to believe in the MS documentation
=============================================
The Jet Replication Wiki's article of caveats that should be in the
MS documentation about Jet Replication:
http://dfenton.com/DFA/Replication/index.php?title=Things_not_to_beli
eve_in_the_MS_documentation
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 by
Michael Kaplan and other experienced users of Jet Replication.
