The access database that I work with contains information which I create/own, and some information from another database which I do not own. I communicate regularly with the owner of the "other database" who tells me, whenever the data in the "other database" changes. When the "other database" changes, I must update my database. We would like to verify the data I update from the "other database" into my database matches the data in the "other database" (errors could occur if the "other database" changed and I was not notified, or from a keystroke error when I was entering data). One method we are considering is to query both databases and compare the query results.
Is there a product that can automate the comparison of the data within the 2 databases, and identify data that does not match? I am considering using the "document compare" feature in MS word, but feel that there may be products available that are specialize in performing this comparison.
Will you please suggest methods to perform this comparison?