Replication using Access 97
Posted on 2001-06-12
I have looked all over and I am unable to find much information on this...when replicating data in Access 97, what happens with the records that contain errors? For example, what happens if database A and database B both contain a record with the primary key = 1234? In this case, we would have a primary key violation....what happens during synchronization? Are these records dumped into a table where a report can be generated and the data manually cleaned? From what I've read, Access will not try to resolve conflicts but I've not found anything that says what it WILL do in these cases. Thanks!