Ureader.com  
Microsoft software help and Community
   home   |   control panel login   |   archive   |  
 
Access
3rdpartyusrgrp
access
activexcontrol
adp.sqlserver
commandbarsui
conversion
dataaccess.pages
developers.toolkitode
devtoolkits
externaldata
forms
formscoding
gettingstarted
internet
interopoledde
macros
modulescoding
modulesdaovba
modulesdaovba.ado
multiuser
odbcclientsvr
queries
replication
reports
security
setupconfig
tablesdbdesign
  
 
date: Sat, 24 Nov 2007 10:52:15 -0500,    group: microsoft.public.access.replication        back       


What is replication?   
I'm confused as to what replication is.  Is replication used when there is 
no network available or it is impossible to install a network (as with 
several employees having laptops that they travel around with)?  Or not? 
How do you go about creating replication?

Robert
date: Sat, 24 Nov 2007 10:52:15 -0500   author:   Robert cpq1bcle[REMOVE]@verizon.net

Re: What is replication?   
Robert wrote:
> I'm confused as to what replication is.  Is replication used when there is 
> no network available or it is impossible to install a network (as with 
> several employees having laptops that they travel around with)?  Or not? 
> How do you go about creating replication?
> 
> Robert 
> 
> 
> 
Suggest you Google search for "Access replication" and do a lot of reading.

Bob
date: Sat, 24 Nov 2007 10:23:19 -0600   author:   lid

Re: What is replication?   
"Robert" <cpq1bcle[REMOVE]@verizon.net> wrote in
news:47484899$0$5279$bbae4d71@news.suddenlink.net: 

> I'm confused as to what replication is.  Is replication used when
> there is no network available or it is impossible to install a
> network (as with several employees having laptops that they travel
> around with)?  Or not? How do you go about creating replication?

Replication allows you to edit two replicas in different locations
and synchronize the data between the two replicas. After a
synchronization, the databases are identical. 

Jet Replication in particular requires a network connection for the
duration of the synchronization, but not a persistent one. And
indirect replication is very efficient and works well even over low
bandwidth and unreliable connections. 

I started using Jet replication with my clients back in the late
1990s to allow them to edit data at multiple offices and still share
it between all users. With the inclusion of Windows Terminal Server
in Windows 2000 Server, I no longer do this for that purpose. In the
case of separate offices, one office sets up a Terminal Server and
everybody in the remote offices edit data on the Terminal Server, so
everybody has current data at all times. Terminal Server works well
with DSL and up -- I have a client with satellite sites with 384K
DSL and it works great. 

I still use Jet Replication to support disconnected users who need
to edit without a network connection. That means mostly laptop users
who have to leave the home office and work without a full-time
network connection. This makes things much easier, especially if
they will only synch when back in the home office, where it's a LAN
connection and can be done with simple direct replication (without
all the complications of installing and configuring the Jet
synchronizer). 

-- 
David W. Fenton                  http://www.dfenton.com/ 
usenet at dfenton dot com    http://www.dfenton.com/DFA/
date: 25 Nov 2007 00:35:25 GMT   author:   David W. Fenton lid

Re: What is replication?   
Thank you.

"David W. Fenton" <XXXusenet@dfenton.com.invalid> wrote in message 
news:Xns99F2C734CDA2Cf99a49ed1d0c49c5bbb2@66.250.146.128...
> "Robert" <cpq1bcle[REMOVE]@verizon.net> wrote in
> news:47484899$0$5279$bbae4d71@news.suddenlink.net:
>
>> I'm confused as to what replication is.  Is replication used when
>> there is no network available or it is impossible to install a
>> network (as with several employees having laptops that they travel
>> around with)?  Or not? How do you go about creating replication?
>
> Replication allows you to edit two replicas in different locations
> and synchronize the data between the two replicas. After a
> synchronization, the databases are identical.
>
> Jet Replication in particular requires a network connection for the
> duration of the synchronization, but not a persistent one. And
> indirect replication is very efficient and works well even over low
> bandwidth and unreliable connections.
>
> I started using Jet replication with my clients back in the late
> 1990s to allow them to edit data at multiple offices and still share
> it between all users. With the inclusion of Windows Terminal Server
> in Windows 2000 Server, I no longer do this for that purpose. In the
> case of separate offices, one office sets up a Terminal Server and
> everybody in the remote offices edit data on the Terminal Server, so
> everybody has current data at all times. Terminal Server works well
> with DSL and up -- I have a client with satellite sites with 384K
> DSL and it works great.
>
> I still use Jet Replication to support disconnected users who need
> to edit without a network connection. That means mostly laptop users
> who have to leave the home office and work without a full-time
> network connection. This makes things much easier, especially if
> they will only synch when back in the home office, where it's a LAN
> connection and can be done with simple direct replication (without
> all the complications of installing and configuring the Jet
> synchronizer).
>
> -- 
> David W. Fenton                  http://www.dfenton.com/
> usenet at dfenton dot com    http://www.dfenton.com/DFA/
>
date: Sun, 25 Nov 2007 20:04:13 -0500   author:   Robert cpq1bcle[REMOVE]@verizon.net

Re: What is replication?   
Thank you.
<user@domain.invalid> wrote in message 
news:e9dSLZrLIHA.4948@TK2MSFTNGP02.phx.gbl...
> Robert wrote:
>> I'm confused as to what replication is.  Is replication used when there 
>> is no network available or it is impossible to install a network (as with 
>> several employees having laptops that they travel around with)?  Or not? 
>> How do you go about creating replication?
>>
>> Robert
> Suggest you Google search for "Access replication" and do a lot of 
> reading.
>
> Bob
>
date: Sun, 25 Nov 2007 20:04:47 -0500   author:   Robert cpq1bcle[REMOVE]@verizon.net

Google
 
Web ureader.com


    COPYRIGHT 2007, YARDI TECHNOLOGY LIMITED, ALL RIGHT RESERVE  |   contact us