Discussion:
Will Access Be Replicated and Synchronized Like MS Replication Man
(too old to reply)
Mr. JYC
2009-05-12 00:41:01 UTC
Permalink
Hello,

Let's say FRS is implemented in either Windows 2003 Servers or Window 2008
Servers in a WAN. Access 2003 databases will be stored on those servers.
Would the replication that takes place be the same as using MS Replication
Manager 4.0 which is included with Access 2003? Is it better? If so what
version of Windows Server should be used?
--
Thank you for your help!
JYC
Anthony [MVP]
2009-05-12 09:25:57 UTC
Permalink
There are two sides to this:
DFSR is a more efficient file replication mechanism than FRS, so using
Server 2003 R2 or Server 2008 will be better than using Server 2003 pre-R2.
Database replication is problematic because of:
- locking
- conflicts caused by simultaneous writes

If you have a simple read-only Access database that gets updated from time
to time, then DFSR will be fine. If not, then its probably time to move to
SQL mirroring.

You might get more options by asking in the Office or Access newsgroups,
Hope that helps,
Anthony
http://www.airdesk.com
Post by Mr. JYC
Hello,
Let's say FRS is implemented in either Windows 2003 Servers or Window 2008
Servers in a WAN. Access 2003 databases will be stored on those servers.
Would the replication that takes place be the same as using MS Replication
Manager 4.0 which is included with Access 2003? Is it better? If so what
version of Windows Server should be used?
--
Thank you for your help!
JYC
Loading...