Compare Data in Two Tables

[Andrew Huckerby]

I have two tables, one a master and the second is one
which occasionaly gets out of sync with the master. Is
there an easy way which i can compare every field of both
tables to find any differences. Then on finding the
differences, display them and request the user to
authorise the update of the master table from the second?

Any help would be much appreciated.

 

[FreD]

WHAT YOU NEED TO DO IS SIMPLY RUN A QUERY AND USE THE <>
SYMBOL ON THE FIELDS THAT DO NOT MATCH.

 

[RobFMS]

Andrew

If this is something that you do frequently, even with other databases, then
I might suggest looking into this software:

Total Access Detective (trial-version available)
http://www.fmsinc.com/products/detective/index.html

Let me know if you have any questions.

--

Rob
FMS, Inc.

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Need to launch your application in the appropriate version of Access?
http://www.fmsinc.com/Products/startup/index.asp

Need software tools for Access, VB, SQL or .NET?
http://www.fmsinc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-