Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Replication / June 2005

Tip: Looking for answers? Try searching our database.

not syncing

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Bill H. - 28 Jun 2005 03:07 GMT
Have the DM on one computer (win 2k and access 2k) and a replica on a laptop
(win2k and access xp).

Made changes/additions to records of some tables on the laptop.  Used the DM
to sync.  None of the table changes came over!

Tried a couple of syncs, and still no new/changed data.

Any ideas why not?

Thx.

Signature

Bill

David W. Fenton - 28 Jun 2005 16:36 GMT
> Have the DM on one computer (win 2k and access 2k) and a replica
> on a laptop (win2k and access xp).
[quoted text clipped - 5 lines]
>
> Any ideas why not?

First off, don't use the design master for anything but making
design changes. That means in the minimum replication configuration,
you'll have the DM plus two replicas, one local for editing, one
remote for editing. The DM is synched only for two reasons:

1. to propagate design changes

2. to keep it from expiring (at least once a month or so, depending
on your expiration period; the default is 1000 days).

Now, the second issue is that you should replicate only tables, not
forms/reports, because the latter just doesn't work. The reasons why
are kind of complicated so I won't go into them, but the result of
replicating front objects is usually a corrupted replica set.

One of the symptoms of that kind of corruption is that changes just
stop propagating.

There should be synch errors or conflicts reported to you if you
open the design master or the replica.

Signature

David W. Fenton                        http://www.bway.net/~dfenton
dfenton at bway dot net                http://www.bway.net/~dfassoc

Bill H. - 28 Jun 2005 18:35 GMT
OK, but if the DM is synced (periodically) with one of the replicas
containing data, won't the DM then have the same data as the replica?

--Bill
David W. Fenton - 28 Jun 2005 23:04 GMT
> OK, but if the DM is synced (periodically) with one of the
> replicas containing data, won't the DM then have the same data as
> the replica?

Yes, of course. Why would that be a problem?

The problem is in exposing it to the danger of using it for
production editing, where it's subject to corruption.

Signature

David W. Fenton                        http://www.bway.net/~dfenton
dfenton at bway dot net                http://www.bway.net/~dfassoc

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.