I have a problem replicating two remote databases. They are exactly the same schema wise etc but obviously the data is different from one location to the next.
On replication one table called Diary is not combined with its replica it just overwrites it and all the new entries from one location are lost!
Does anybody know what the problem is? and how i can solve this other than copying and pasting or using an append query?
Access sometimes does not even replicate and creates a new blank database called RecMsg and produces an error record has been deleted from the Table Diary when it hasnt. has anybody come across this before?
thanks for your time