Tool for Comparing Access Databases

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?
mabobbinAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

celticsCommented:
What you are considering as far as querying the databases is what I have done, quick and easy.
0
mabobbinAuthor Commented:
Were there any commercial tools that can identify where the data does not match, I am concerned that since word is not optimized for this type of comparison, I may end up spending lots of time dealing with special cases.  

In reading my original statement of the problem, I failed to mention that the databases are quite large 15 MB, with thousands of records.
0
karlovaCommented:
http://www.hallogram.com/totalaccess/detective/index.html (I have not used it but it looks like what your looking for)
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
DedushkaCommented:
Hi mabobbin.
There are standard feature in MS Access named "replication". It allows you to create "replicas" and sinchronize them. You just need to read about replication in Online Help.

karlova: about Total Access Detective.

Total Access Detective 2000 lets you pinpoint the exact changes between any two objects in one database, or objects between two databases. Detect changes in objects, fields, controls, properties, and code. Even detect changes in your data!

Best of all, the beta version of Total Access Detective 2000 is available
for FREE from http://www.fmsinc.com/products/detective/TAD2000/



Regards,
Dedushka
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Hardware

From novice to tech pro — start learning today.