Hi,
I'm completely stuck and could really do with some straight forward
instructions on setting up Replication with Indirect Synchronization.
Here's the situation...
- I'm using Access 2003.
- I have two PC's connected over a LAN (I need Indirect Sync as one
will be connecting via a VPN soon).
- I have created a database on PC1 and used the TSI synchronizer
sample code to make a replica directly on the Hard drive of PC2.
- I do not have access to the Replication Manager software.
- Each PC has a dropbox at c:\dropbox, shared as 'dropbox' with (as
far as I can tell) all the correct read/write permissions. I can see
each dropbox from the other PC using Explorer.
- Each PC runs the MSTran40.exe and regedit shows FSAddress pointing
to the other PC's dropbox.
- I use the following code in each DB to perform the sync.
Dim sync As Synchronizer
Dim reps As Replicas
Dim rep As Replica
Set sync = New Synchronizer
'Set reps = sync.ReplicaSet
sync.Running = True
sync.IndirectDropbox = "\\PC2\dropbox"
sync.DatabaseName = "C:\reptest\MasterDB.mdb"
Set reps = sync.ReplicaSet
For Each rep In reps
If rep.ReplicaID <> sync.ReplicaID Then
sync.SynchIndirect rep.SynchronizerID
End If
Next rep
sync.Running = False
Set sync = Nothing
- When I first run it on each PC, it writes the WingMan.sgn file in
the other PCs dropbox.
My problem is that it never ever writes any msg files, even though the
sync completes without errors and I have added/changed data on the
tables!!!
Please help - What am I missing here? I've tried my best reading
articles on the net (including those by D. Fenton), but am well and
truly stuck!
Thanks.
Martyn.
