Hello I'm rather new to Replication in Access; I've been working on a
test environment trying to get indirect replication to work for about
2-3 weeks now and every time I think I've got it working it fails. I
have downloaded TSI Synch 4.0 and Jet 4.0 and set them up on three
Computers in the office. Following this site
http://www.vsj.co.uk/articles/display.asp?id=560
I've been able to create and move replicas and declare drop boxes for
them. However when I go to Synch the DB's I get the same Error time
and Time again. " you must have a DB open to perform this operation.
Set the databasename Property to load a DB." On line six of this code
1. Private Sub Command109_Click()
2. Dim sync As Synchronizer
3. Dim reps As Replicas
4. Dim rep As Replica
5. Set sync = New Synchronizer
6. Set reps = sync.ReplicaSet
7. sync.Running = True
8. 'sync.SystemDB = _
9. ' "c:\windows\system32\system.mdw"
10. sync.IndirectDropbox = "c:\dropbox"
11. 'sync.IndirectDropboxPwd = "password"
12. sync.DatabaseName = _
13. "C:\Rep_Testing\ReadyContactsDev.mdb"
14. Set reps = sync.ReplicaSet
15. For Each rep In reps
16. If rep.ReplicaID <> _
17. sync.ReplicaID Then
18. sync.SynchIndirect _
19. rep.SynchronizerID
20. End If
21. Next rep
22. End Sub
I know that a thousand other people have complained about there being
no do***entation for the TSI library for me I've found enough to
understand and get it up but I just can't seem to get the most
im****tant part to work the actual SYNCH and I know I just messed up
something simple or for forgot something stupid, so please any input
would be appreciated. If you need any more information on my set up
here let me know.
TIA Matt G.
