I am having a problem with Synchronizing Access 2000 databases.
I have a master database from which I created two replicas (say A and B). I have a front end application which I link all of the tables from replica A. I then start the application and enter a single record in a table in replica A.
I then remove all of the linked tables from A in the main front end and then link all of the tables from replica B. I then add in the same record as in A. My purpose was to see if the duplicate record was handled and see the conflict generated.
When I synchronize Replica A and Replica B together I get an error "Synchronization Failed between A and B. The last line in the displayed message is "Index not found".
I cannot find this error anywhere or what it means. I have successfully synchronized A with the design master and B with the design master but whenever I change the record from the front end and then try to sync A and B I get the above error.
I have never had this type of problem surface with any of the replicated database I have built in Access 97 or 2000 until now.
Any thoughts or suggestions?
Thanks in advance.
I have a master database from which I created two replicas (say A and B). I have a front end application which I link all of the tables from replica A. I then start the application and enter a single record in a table in replica A.
I then remove all of the linked tables from A in the main front end and then link all of the tables from replica B. I then add in the same record as in A. My purpose was to see if the duplicate record was handled and see the conflict generated.
When I synchronize Replica A and Replica B together I get an error "Synchronization Failed between A and B. The last line in the displayed message is "Index not found".
I cannot find this error anywhere or what it means. I have successfully synchronized A with the design master and B with the design master but whenever I change the record from the front end and then try to sync A and B I get the above error.
I have never had this type of problem surface with any of the replicated database I have built in Access 97 or 2000 until now.
Any thoughts or suggestions?
Thanks in advance.